• Management Pack:  SQL Server 2012
  • MP Version:  6.7.7.0
  • Released:  10/6/2016
  • Publisher:  Microsoft

SQL Server 2012 DB Class

  • ID:  Microsoft.SQLServer.2012.Database
  • Description:  Microsoft SQL Server 2012 database
  • Class Hierarchy: 
    Entity
    Logical Entity
    Application Component
    Database
    SQL Database
    SQL Server 2012 DB

  • 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 DBs 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™. 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 DBs Disk Write Latency monitor for 2012 DBs 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. Average Wait Time monitor for 2012 DBs 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. 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. 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. Monitors the space available on a log file and on the media hosting the log in percentage terms. The monitor reports a warning when the free space drops below the Warning Threshold setting, expressed as percentage of the sum of data size. The monitor reports a critical alert when the free space drops below the Critical Threshold. Microsoft SQL Server 2012 database All Microsoft SQL Server 2012 distributors.  The distributor is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. An installation of Microsoft SQL Server 2012 Database Engine.  The database engine hosts databases and other SQL Server components. Custom User Policy which has Database as Facet and one of the error categories as Policy Category. Custom User Policy which has Database as Facet and one of the warning categories as Policy Category. Microsoft SQL Server 2012 database Filegroup Microsoft SQL Server 2012 database log file Microsoft SQL Server 2012 FILESTREAM Filegroup

Download diagram as a Visio file

Properties

Display Name Description
Collation  
Database Autogrow Set  
Database Name (Key)  
Database Size (MB) (Numeric) (Deprecated)  
Database Size (MB) (String) (Deprecated)  
Display Name Display name of monitoring object.
Log Autogrow Set  
Log Size (MB) (Numeric) (Deprecated)  
Log Size (MB) (String) (Deprecated)  
Owner  
Recovery Model  
Updateability  
User Access  

Discovered By

Name Description
Discover Databases for a Database Engine This object discovery discovers all databases running for a given instance of SQL Server 2012 DB Engine. By default, all databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.

Relations

Health Source
NameClassType
SQL Server 2012 Database Hosts Filegroup SQL Server 2012 DB Hosting
SQL Server 2012 Database Hosts FILESTREAM Filegroup SQL Server 2012 DB Hosting
SQL Server 2012 Database Hosts Log File SQL Server 2012 DB Hosting
SQL Server 2012 Database Hosts Publication SQL Server 2012 DB Hosting
SQL Server 2012 Database Hosts Subscription SQL Server 2012 DB Hosting
SQL Server 2012 Database hosts Critical User Policy SQL Server 2012 DB Hosting
SQL Server 2012 Database hosts Warning User Policy SQL Server 2012 DB Hosting
Entity Watched By Perspective Entity Reference

Health Target
NameClassType
SQL Server 2012 Distributer Contains SQL Server 2012 Database SQL Server 2012 DB Membership
SQL Server 2012 Databases Group Contains Database SQL Server 2012 DB Membership
SQL Database Engine Hosts SQL Database SQL Database Hosting
Microsoft.SQLServer.DatabaseGroupContainsDatabase SQL Database Membership

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

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