• Custom Reports - VMware Events

    This custom report can be used to show all events for a specific VM by name. Events include powering on/off a VM, a VM moved from one ESX host to another, etc. before running this script, modify the value of @VMName a...
    Profile Photo
    last modified by darichar
  • Custom Report - VMware Metric Detail

    This custom report will return VMware metric details for the metric name provided in the @MetricName variable and the database name provided in @DBName. The report will also be limited to the date range specified in t...
    Profile Photo
    last modified by darichar
  • O/S CPU Queue Length - uses WMI

    Description DPA stopped using the sp_OA procedures to collect O/S level metrics and started using DMVs. However, the metric O/S CPU Queue Length was not available within a DMV so it was excluded. This document explain...
    Profile Photo
    last modified by darichar
  • CUSTOM METRIC - SYBASE CPU BUSY

    DESCRIPTIONThis custom metric will collect the percentage of CPU work the Adaptive Server spent since the last time Adaptive Server was started.    METRIC DEFINITIONTo create the custom metric, click on Opt...
    Profile Photo
    last modified by ashrecksiedler
  • Custom Alert - Monitor Service Broker Queue Tables

    Description This alert will count the rows in any queue tables and alert you when they are high. If they are high, this could indicate tasks are not getting processed in a timely fashion or processed at all.   Al...
    Profile Photo
    last modified by darichar
  • Custom Alert - Plan Changes with Higher Wait Times

    Description This alert will determine if any SQL had a plan change that resulted in a higher amount of wait time. Plan changes are not necessarily bad, but if the wait times go up, that is a good indication the new pl...
  • Custom Alert - Abnormal SQL Execution Time

    DESCRIPTIONThis alert will list SQL Statements that have recently executed outside their normal execution time. The previous 14 days are compared when calculating the average execution time for a SQL. The results are ...
    Profile Photo
    last modified by ashrecksiedler
  • Custom Alert - Blocked Sessions - From Instance

    Description This alert will run against the monitored instance and retrieve the time each session has been blocked ("Seconds Blocked" column).  It will also give some details about the blocking session in the "Me...
    Profile Photo
    last modified by jaminsql
  • Custom Alert - Sybase Database Freespace

    DESCRIPTION This alert replaces the canned Ignite Database Freespace alert for Sybase and is improved in two ways:   The canned alert will error if there are any databases that are no online when it executes. Th...
    Profile Photo
    last modified by darichar
  • Custom Alert - Commit Latency

    DESCRIPTIONThis alert will review the Disk Write Time - Commits metric collected by Ignite and provide a warning when the metric goes above 15 ms and a critical alert when it goes above 20 ms. The metric is averaged o...
    Profile Photo
    last modified by DanielleH
  • Custom Alert - Long Running Queries

    DESCRIPTIONThis alert is for SQL Server instances only and will tell you when SQL statements have executed more than a defined amount of time. This example uses a 300 second threshold, meaning any SQL statements that ...
    Profile Photo
    last modified by shaulis
  • AG Metrics - Average Log Send Rate for all Secondary Replicas

    Description The Average Log Send Rate metrics utilizes the log_send_rate column in the sys.dm_hadr_database_replica_states dynamic management view that reports the average rate at which the primary replica instance se...
    Profile Photo
    last modified by ashrecksiedler
  • AG Metrics - Average Redo Rate across all Secondary Replica Databases

    Description The Average Redo Rate across all Secondary Replicas metric utilizes the redo_rate collumn in the sys.dm_hadr_database_replica_states dynamic management view that reports the rate at which the log records a...
    Profile Photo
    last modified by ashrecksiedler
  • AG Metric - Average Redo Queue Size across all Secondary Replicas

    Description The Average Redo Queue Size across all Secondary Replicas metric utilizes the redo_queue_size column in the sys.dm_hadr_database_replica_states dynamic management view that reports the amount of log record...
    Profile Photo
    last modified by ashrecksiedler
  • ss TopSQLforDatabase SQL

    IF (SELECT COUNT(*) FROM SYS.OBJECTS WHERE NAME LIKE 'TopSQLforDatabase') = 1 DROP PROC TopSQLforDatabase GO   -- TopSQLforDatabase PROC -- -- PARMS '@FROM_DATE', '@TO_DATE', '@CONDNAME' , '@DBNAME' -- EXA...
    Profile Photo
    last modified by mandevil
  • Custom Alert - SQL Server Backup Monitoring

    DESCRIPTIONThis alert will detect databases that have not had a backup done within the last day. It will provide a simple count, and any return of 1 or more (at least one backup for a database has failed) will trigger...
    Profile Photo
    last modified by jaminsql
  • Custom Metric - TempDB Free Space Percent

    Description This custom metric will collec the current free space for TempDB as a percentage.   Metric Definition To create the custom metric, click on Options > Custom Resource Metrics and configure the metri...
    Profile Photo
    last modified by DanielleH
  • Custom Alert - SQL Server Database Size Collector

    DESCRIPTIONThis alert will collect the size each database in a SQL instance. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert na...
    Profile Photo
    last modified by darichar
  • Custom Alert - Tablespace Growth Percent

    Description This alert uses the data collected by the Collect Tablespace Sizes alert job and calculates the growth from one collection to the next. It can then alert when any tablespace grows by more than X% as define...
  • Custom Alert - SQL Statements with Abnormal Execution Counts

    Description This alert will tell you when an SQL statement has executed more often than it normally does. This example uses a 200% threshold, meaning the SQL has executed twice as many times as normal. The alert defin...
    Profile Photo
    last modified by DanielleH