• 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
  • Custom Report - VMware Host Disk Device Latencies

    Description This alert will calculate the average host disk device read and write latency metrics for last 10 minutes (based on frequency of alert) and send an email when the value is over 15% (warning) or 30% (critic...
    Profile Photo
    last modified by darichar
  • Change_physical_node_name.docx

    This document describes how to set up two DPA Alerts to monitor cluster fail overs including AlwaysOn environments to notify you when a failover occurs and to change the Database Instance name to include the actual ph...
    Profile Photo
    last modified by mandevil
  • Custom Alert - SQL Server Database Growth

    DESCRIPTIONThis alert works in conjunction with the SQL Server Database Size Collector alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of d...
    Profile Photo
    last modified by jaminsql