• Management Pack:  SQL Server
  • MP Version:  6.3.173.1 for SQL Server 2012
  • Released:  8/20/2012
  • Publisher:  Microsoft

Unit Monitors

Name Enabled Target Class Alert Message Description
Unit Monitor   Auto Close Configuration
0
 
SQL Server 2012 DB Auto Close Configuration Error Monitors the auto close setting for the database
Unit Monitor   Auto Create Statistics Configuration
0
 
SQL Server 2012 DB Auto Create Statistics Configuration Error Monitors the auto create statistic setting for the database
Unit Monitor   Auto Shrink Configuration
0
 
SQL Server 2012 DB Auto Shrink Configuration Error Monitors the auto shrink setting for the database
Unit Monitor   Auto Update Statistics Async Configuration
0
 
SQL Server 2012 DB Auto Update Statistics Async Configuration Error Monitors the auto update statistics async setting for the database
Unit Monitor   Auto Update Statistics Configuration
0
 
SQL Server 2012 DB Auto Update Statistics Configuration Error Monitors the auto update statistics setting for the database
Unit Monitor   Availability Database Data Synchronization
1
 
Database Replica   Availability Database Data Synchronization
Unit Monitor   Availability Database Join State
1
 
Database Replica   Availability Database Join State
Unit Monitor   Availability Database Suspension State
1
 
Database Replica   Availability Database Suspension State
Unit Monitor   Availability Group Automatic Failover monitor
1
 
Availability Group Health   Availability Group Automatic Failover
Unit Monitor   Availability Group Health Policy
1
 
Availability Group Critical Policy   Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined error categories as Policy Category.
Unit Monitor   Availability Group Health Policy
1
 
Availability Group Warning Policy   Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined warning categories as Policy Category.
Unit Monitor   Availability Group Online monitor
1
 
Availability Group Health   Availability Group Online
Unit Monitor   Availability Replica Connection
1
 
Availability Replica   Availability Replica Connection
Unit Monitor   Availability Replica Data Synchronization
1
 
Availability Replica   Availability Replica Data Synchronization
Unit Monitor   Availability Replica Health Policy
1
 
Availability Replica Critical Policy   Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined error categories as Policy Category.
Unit Monitor   Availability Replica Health Policy
1
 
Availability Replica Warning Policy   Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined warning categories as Policy Category.
Unit Monitor   Availability Replica Join State
1
 
Availability Replica   Availability Replica Join State
Unit Monitor   Availability Replica Role
1
 
Availability Replica   Availability Replica Role
Unit Monitor   Availability Replicas Connection monitor
1
 
Availability Group Health   Availability Replicas Connection
Unit Monitor   Availability Replicas Data Synchronization monitor
1
 
Availability Group Health   Availability Replicas Data Synchronization
Unit Monitor   Availability Replicas Role monitor
1
 
Availability Group Health   Availability Replicas Role
Unit Monitor   Blocking Sessions
0
 
SQL Server 2012 DB Engine Blocked Session(s) Monitors blocked sessions for a SQL instance.
Unit Monitor   Database Backup Status
0
 
SQL Server 2012 DB Database backup should be performed This monitor checks the status of the database backup as reported by Microsoft® SQL Server™.
Unit Monitor   Database Health Policy
1
 
Database Critical Policy   Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Database as Facet and one of the predefined error categories as Policy Category.
Unit Monitor   Database Health Policy
1
 
Database Warning Policy   Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Database as Facet and one of the predefined warning categories as Policy Category.
Unit Monitor   Database Replica Health Policy
1
 
Database Replica Critical Policy   Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined error categories as Policy Category.
Unit Monitor   Database Replica Health Policy
1
 
Database Replica Warning Policy   Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined warning categories as Policy Category.
Unit Monitor   Database Status
1
 
SQL Server 2012 DB Database Offline This monitor checks the status of the database as reported by Microsoft® SQL Server™.
Unit Monitor   DB Chaining Configuration
0
 
SQL Server 2012 DB DB Chaining Configuration Error Monitors the DB chaining setting for the database
Unit Monitor   DB File Space
1
 
SQL Server 2012 DB File   Monitors the space available on a database file and on the media hosting the file in percentage terms.
Unit Monitor   DB Log File Space
1
 
SQL Server 2012 DB Log File   Monitors the space available on a log file and on the media hosting the log in percentage terms.
Unit Monitor   DB Space Percentage Change
0
 
SQL Server 2012 DB Significant Percentage Change in DB Total Free Space Monitors for a large change in value of database available space over a set number of sample periods.
Unit Monitor   DB Total Space
0
 
SQL Server 2012 DB Database Out of Space Monitors the space available in the database and on the media hosting the database in percentage terms.
Unit Monitor   Destination Log Shipping
1
 
SQL Server 2012 DB Log Shipping Destination This monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration.
Unit Monitor   Job Duration
1
 
SQL Server 2012 Agent Job   Monitors Agent Job Duration.
Unit Monitor   Last Run Status
1
 
SQL Server 2012 Agent Job   SQL 2012 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.
Unit Monitor   Long Running Jobs
0
 
SQL Server 2012 Agent Long Running Jobs This monitor checks for long running SQL Agent jobs.
Unit Monitor   Page Verify Configuration
0
 
SQL Server 2012 DB Page Verify Configuration Error Monitors the page verify setting for the database.
Unit Monitor   Recovery Model Configuration
0
 
SQL Server 2012 DB Recovery Model Configuration Error Monitors the recovery model setting for the database.
Unit Monitor   Service Pack Compliance
1
 
SQL Server 2012 DB Engine Service Pack Compliance Monitors the service pack level of the database engine against the compliant setting
Unit Monitor   Service Principal Name Configuration Status
1
 
SQL Server 2012 DB Engine SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated. This monitor checks the status of the Microsoft® SQL Server™ instance Service Principal Name configuration.
Unit Monitor   Source Log Shipping
1
 
SQL Server 2012 DB Log Shipping Source This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration.
Unit Monitor   SQL Server Agent Windows Service
1
 
SQL Server 2012 Agent SQL Server Agent Windows Stopped This monitor checks the status of the SQL Agent service for this instance of SQL Server.
Unit Monitor   SQL Server Analysis Services Windows Service
1
 
SQL Server 2012 Analysis Services SQL Server Analysis Services Windows Stopped This monitor checks the status of the SQL Analysis Services service.
Unit Monitor   SQL Server Full Text Search Service
0
 
SQL Server 2012 DB Engine SQL Server Full Text Search Service Stopped This monitor checks the status of the SQL Full Text Search service.
Unit Monitor   SQL Server Integration Services Windows Service
1
 
SQL Server 2012 Integration Services SQL Server Integration Services Windows Service Stopped This monitor checks the status of the SQL Integration Services service.
Unit Monitor   SQL Server Reporting Services Windows Service
1
 
SQL Server 2012 Reporting Services SQL Server Reporting Services Stopped This monitor checks the status of the SQL Reporting Services service.
Unit Monitor   SQL Server Windows Service
1
 
SQL Server 2012 DB Engine SQL Server Service Stopped This monitor checks the status of the SQL Database Engine service.
Unit Monitor   SQL Server Windows Service
1
 
SQL Server 2012 DB   This monitor checks the status of the SQL Database Engine service.
Unit Monitor   SQL User Connections Performance
0
 
SQL Server 2012 DB Engine SQL User Connections Abnormal This monitor analysis the user connections to the SQL database engine over time and calculates a baseline over the initial learning period.
Unit Monitor   Synchronous Replicas Data Synchronization monitor
1
 
Availability Group Health   Synchronous Replicas Data Synchronization
Unit Monitor   Trustworthy Configuration
0
 
SQL Server 2012 DB Trustworthy Configuration Error Monitors the trustworthy setting for the database
Unit Monitor   WSFC Cluster monitor
1
 
Availability Group Health   WSFC Cluster monitor

See Also for SQL Server Management Pack


Downloads for SQL Server Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED