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

SQL Database Class

  • ID:  Microsoft.SQLServer.Database
  • Description:  All Microsoft SQL Server 2008, 2008 R2, and 2012 databases.
  • Class Hierarchy: 
    Entity
    Logical Entity
    Application Component
    Database
    SQL Database

  • Attributes:  Public, Hosted
Login
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 2008 Databases. Buffer Cache Hit Ratio for 2008 DB Engine CPU Utilization (%) for 2008 DB Engine Page Life Expectancy (s) for 2008 DB Engine Stolen Server Memory for 2008 DB Engine Thread Count for 2008 DB Engine Monitors blocked sessions for an SQL instance. SQL Re-Compilation for 2008 DB Engine This monitor analysis the user connections to the SQL database engine over time, and calculates a baseline over the initial learning period. All Microsoft SQL Server 2008, 2008 R2, and 2012 databases. An installation of Microsoft SQL Server 2008 Database Engine. The database engine hosts databases and other SQL Server components.

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

There are no discoveries discovered this class.

Relations

Health Source
NameClassType
Entity Watched By Perspective Entity Reference

Health Target
NameClassType
SQL Database Engine Hosts SQL Database SQL Database Hosting
Microsoft.SQLServer.DatabaseGroupContainsDatabase SQL Database Membership

Class Knowledgebase

Summary

All Microsoft SQL Server 2008, 2008 R2, and 2012 databases.

External References
This class does not contain any external references.

See Also for SQL Server 2008 Management Pack


Downloads for SQL Server 2008 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