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

Unit Monitors

Name Enabled Target Class Alert Message Description
Unit Monitor   Auto Close Configuration
0
 
SQL Server 2008 DB Auto Close Configuration Error Monitors the auto close setting for the database
Unit Monitor   Auto Create Statistics Configuration
0
 
SQL Server 2008 DB Auto Create Statistics Configuration Error Monitors the auto create statistic setting for the database
Unit Monitor   Auto Shrink Configuration
0
 
SQL Server 2008 DB Auto Shrink Configuration Error Monitors the auto shrink setting for the database
Unit Monitor   Auto Update Statistics Async Configuration
0
 
SQL Server 2008 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 2008 DB Auto Update Statistics Configuration Error Monitors the auto update statistics setting for the database
Unit Monitor   Blocking Sessions
0
 
SQL Server 2008 DB Engine Blocked Session(s) Monitors blocked sessions for a SQL instance.
Unit Monitor   Database Backup Status
0
 
SQL Server 2008 DB Database backup should be performed This monitor checks the status of the database backup as reported by Microsoft® SQL Server™.
Unit Monitor   Database Mirror Status
1
 
SQL 2008 Mirrored DB Database Mirror is not Synchronized This monitor checks if database mirror is synchronized.
Unit Monitor   Database Mirror Witness Status
1
 
SQL 2008 Mirrored DB Database Mirror Witness is not accessible This monitor checks if database mirror witness is accessible.
Unit Monitor   Database Mirroring Partners Status
1
 
SQL 2008 Mirrored DB Witness Database mirroring partners are not synchronized This monitor checks if database mirror is synchronized.
Unit Monitor   Database Status
1
 
SQL Server 2008 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 2008 DB DB Chaining Configuration Error Monitors the DB chaining setting for the database
Unit Monitor   DB File Space
1
 
SQL Server 2008 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 2008 DB Log File   Monitors the space available on a log file and on the media hosting the log in percentage terms.
Unit Monitor   DB Log File Space Free (%) : DEPRECATED
0
 
SQL Server 2008 DB Log Files Out of Space This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log in percentage terms.
Unit Monitor   DB Log File Space Free (MB) : DEPRECATED
0
 
SQL Server 2008 DB Log Files Out of Space This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log files in megabytes.
Unit Monitor   DB Space Free (MB) : DEPRECATED
0
 
SQL Server 2008 DB   This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes.
Unit Monitor   DB Space Percentage Change
0
 
SQL Server 2008 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 2008 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 2008 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   Disk Free Space : DEPRECATED
0
 
SQL Server 2008 DB File Disk Space Is Getting Low Monitors the free space percentage left on a disk drive.
Unit Monitor   Job Duration
1
 
SQL Server 2008 Agent Job   Monitors Agent Job Duration.
Unit Monitor   Last Run Status
1
 
SQL Server 2008 Agent Job   SQL 2008 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.
Unit Monitor   Long Running Jobs
0
 
SQL Server 2008 Agent Long Running Jobs This monitor checks for long running SQL Agent jobs.
Unit Monitor   Page Verify Configuration
0
 
SQL Server 2008 DB Page Verify Configuration Error Monitors the page verify setting for the database.
Unit Monitor   Recovery Model Configuration
0
 
SQL Server 2008 DB Recovery Model Configuration Error Monitors the recovery model setting for the database.
Unit Monitor   Service Pack Compliance
1
 
SQL Server 2008 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 2008 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 2008 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 2008 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 2008 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 2008 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 2008 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 2008 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 2008 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 2008 DB   This monitor checks the status of the SQL Database Engine service.
Unit Monitor   SQL User Connections Performance
0
 
SQL Server 2008 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   Trustworthy Configuration
0
 
SQL Server 2008 DB Trustworthy Configuration Error Monitors the trustworthy setting for the database

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