• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

SQL Server 2012 DB Engine Class

  • ID:  Microsoft.SQLServer.2012.DBEngine
  • Description:  An installation of Microsoft SQL Server 2012 Database Engine. The database engine hosts databases and other SQL Server components.
  • Class Hierarchy: 
    Object
    Configuration Item
    Logical Entity
    Computer Role
    Windows Computer Role
    SQL Role
    SQL DB Engine
    SQL Server 2012 DB Engine

  • Attributes:  Public, Hosted
Login
Monitors the auto close setting for the database Monitors the auto create statistic setting for the database Monitors the auto shrink setting for the database Monitors the auto update statistics async setting for the database Monitors the auto update statistics setting for the database Monitors the DB chaining setting for the database Monitors the trustworthy setting for the database Monitors the page verify setting for the database. Monitors the recovery model setting for the database. Monitors for a large change in value of database free space over a set number of sample periods. Monitors the space available in the database and on the media hosting the database in percentage terms. Note that this monitor does not count free space for FILESTREAM Filegroups. Transaction Log Free Space (%) monitor for 2012 Databases. Monitors the auto close setting for the database Monitors the auto create statistic setting for the database Monitors the auto shrink setting for the database Monitors the auto update statistics async setting for the database Monitors the auto update statistics setting for the database Monitors the DB chaining setting for the database Monitors the trustworthy setting for the database Monitors the page verify setting for the database. Monitors the recovery model setting for the database. Monitors for a large change in value of database free space over a set number of sample periods. Monitors the space available in the database and on the media hosting the database in percentage terms. Note that this monitor does not count free space for FILESTREAM Filegroups. Transaction Log Free Space (%) monitor for 2012 Databases. This monitor checks the status of the SQL Database Engine service. This monitor checks the status of the SQL Full-text Filter Daemon Launcher service. Note that SQL Full-text Search feature is not available in any edition of SQL Server Express, except SQL Server Express with Advanced Services. This monitor is disabled by default. Please use overrides to enable it when necessary. Monitors the service pack level of the database engine against the compliant setting This monitor checks the status of the Microsoft® SQL Server™ instance Service Principal Name configuration. Note that the monitor is always in 'Healthy' state for non-domain joined machines. Average Wait Time monitor for 2012 Databases. Buffer Cache Hit Ratio for 2012 DB Engine CPU Utilization (%) for 2012 DB Engine Page Life Expectancy (s) for 2012 DB Engine Stolen Server Memory for 2012 DB Engine Thread Count for 2012 DB Engine Monitors blocked sessions for an SQL instance. SQL Re-Compilation for 2012 DB Engine This monitor analysis the user connections to the SQL database engine over time, and calculates a baseline over the initial learning period. This monitor checks the status of the database as reported by Microsoft® SQL Server™. This monitor checks the status of the SQL Database Engine service. This monitor checks the status of the database backup as reported by Microsoft® SQL Server™. Note that the monitor ignores Always On databases. Therefore, it is always 'green' for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group. 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. Note that all Log Shipping is not supported by any edition of SQL Server Express. 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. Note that all Log Shipping is not supported by any edition of SQL Server Express. Disk Read Latency monitor for 2012 Databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Disk Write Latency monitor for 2012 Databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. This monitor checks if database mirror is synchronized. This monitor checks if database mirror witness is accessible. This monitor checks the status of the database as reported by Microsoft® SQL Server™. This monitor checks the status of the SQL Database Engine service. This monitor checks the status of the database backup as reported by Microsoft® SQL Server™. Note that the monitor ignores Always On databases. Therefore, it is always 'green' for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group. 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. Note that all Log Shipping is not supported by any edition of SQL Server Express. 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. Note that all Log Shipping is not supported by any edition of SQL Server Express. Disk Read Latency monitor for 2012 Databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Disk Write Latency monitor for 2012 Databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. An installation of Microsoft SQL Server 2012 Database Engine. The database engine hosts databases and other SQL Server components. Defines the basic properties of computers running Windows operating systems All Microsoft SQL Server 2008, 2008 R2, and 2012 databases. Microsoft SQL Server 2012 database Microsoft SQL Server 2012 Mirrored Database

Download diagram as a Visio file

Properties

Display Name Description
[Deprecated] Replication Distribution Database  
[Deprecated] Replication Working Directory  
Account Name  
Asset Status Asset status
Audit Level  
Authentication Mode  
Cluster  
Connection String  
Display Name Display name of the object.
Edition  
Error Log Location  
Error Reporting Enabled  
Full Text Search Service Name  
Full Text Search Service Name If Clustered Resource  
Install Path  
Instance ID  
Instance Name (Key)  
Instance Type  
Language  
Master Database Location  
Master Database Log Location  
Notes Notes
Object Status Object status
Performance Counter Object Name  
Service Pack Version  
SQL Server Agent Windows Service Name  
SQL Server Agent Windows Service Name If Clustered Resource  
SQL Server Windows Service Name  
SQL Server Windows Service Name If Clustered Resource  
Tcp Port  
Tools Path  
Version  

Discovered By

Name Description
Discover SQL Server 2012 Database Engines (Windows Server) This object discovery discovers all instances of SQL Server 2012 DB Engine running on Windows Servers. By default, all instances are discovered and monitored. You can override the discovery to exclude one or more instances from being discovered using the Exclude List. This list takes a comma-separated list of instances or * wildcard to exclude all instances.

Relations

Health Source
NameClassType
SQL Server 2012 Database Engine Hosts SQL Server 2012 Agent SQL Server 2012 DB Engine Hosting
SQL Server 2012 Database Engine Hosts Distributor SQL Server 2012 DB Engine Hosting
SQL Server 2012 Database Engine Hosts Publisher SQL Server 2012 DB Engine Hosting
SQL Server 2012 Database Engine Hosts Subscriber SQL Server 2012 DB Engine Hosting
MSSQL 2012: SQL Server 2012 Database Engine Hosts SQL Database Local Group SQL Server 2012 DB Engine Hosting
SQL Database Engine Hosts SQL Database SQL DB Engine Hosting
Owned By User Configuration Item Reference
Affects Customers Configuration Item Reference
Serviced By User Configuration Item Reference
Contains Configuration Item Configuration Item Membership
Is Related to Configuration Item Configuration Item Reference
Config Item References Location Configuration Item Reference
Entity Watched By Perspective Object Reference

Health Target
NameClassType
SQL Server 2012 Instance Group Contains Instances SQL Server 2012 DB Engine Membership
MSSQL 2012: SQL Server 2012 DB Engines With Many DBs Group Contains DB Engines SQL Server 2012 DB Engine Membership
SQL Server Express 2012 Instances Group Contains DB Engine SQL Server 2012 DB Engine Membership
SQL Server 2012 Instances Group Contains DB Engine SQL Server 2012 DB Engine Membership
MSSQL 2012: SQL Server 2012 WOW64 Instance Group Contains Instances SQL Server 2012 DB Engine Membership
Instance Group Contains All Instances of SQL DB Engine SQL DB Engine Membership
MSSQL: SQL Server Instance Group Contains Instances SQL DB Engine Membership
Alerts Scope Group L3 Contains Service Roles Relationship SQL Role Membership
Server Roles Group Contains Server Roles Relationship SQL Role Membership
Hosts Windows Computer Role Windows Computer Role Hosting

Class Knowledgebase

Summary
This class does not contain any summary.
External References
This class does not contain any external references.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

Back to top
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