• Management Pack:  SQL Server 2008
  • MP Version:  6.4.0.0
  • Released:  9/10/2013
  • Publisher:  Microsoft

SQL Database Class

  • ID:  Microsoft.SQLServer.Database
  • Description:  All Microsoft SQL Server databases regardless of version
  • 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 Search service. 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 2008 DBs Buffer Cache Hit Ratio for 2008 DB Engine CPU Utilization (%) for 2008 DB Engine Page Life Expectancy (s) for 2008 DB Engine SQL Recompilation for 2008 DB Engine Stolen Server Memory for 2008 DB Engine Thread Count for 2008 DB Engine Monitors blocked sessions for a SQL instance. 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 databases regardless of version An installation of a 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

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 2008 Management Pack


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