• Management Pack:  SQL Server
  • MP Version:  6.1 for SQL Server 2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

SQL 2008 DB Engine Class

  • ID:  Microsoft.SQLServer.2008.DBEngine
  • Description:  An installation of a Microsoft SQL Server 2008 Database Engine. The database engine hosts databases and other SQL Server components.
  • Class Hierarchy: 
    Entity
    Logical Entity
    Computer Role
    Windows Computer Role
    SQL Role
    SQL DB Engine
    SQL 2008 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 available 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. 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 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. 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 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. 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. This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log in percentage terms. This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log files in megabytes. This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes. An installation of a Microsoft SQL Server 2008 Database Engine. The database engine hosts databases and other SQL Server components. All Windows Computers All Microsoft SQL Server databases regardless of version Microsoft SQL Server 2008 database

Download diagram as a Visio file

Properties

Display Name Description
Account Name  
Audit Level  
Authentication Mode  
Cluster  
Connection String  
Display Name Display name of monitoring object.
Edition  
Error Log Location  
Error Reporting Enabled  
Full Text Search Service Name  
Full Text Search Service Name If Clustered Resource  
Install Path  
Instance Name (Key)  
Language  
Master Database Location  
Master Database Log Location  
Performance Counter Object Name  
Replication Distribution Database  
Replication Working Directory  
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  
Tools Path  
Version  

Discovered By

Name Description
Discover SQL 2008 Database Engines (Windows Server) This object discovery discovers all instances of SQL Server 2008 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 instance names or the * character to exclude all instances.

Relations

Health Source
NameClassType
SQL 2008 Database Engine Hosts SQL 2008 Agent SQL 2008 DB Engine Hosting
SQL 2008 Database Engine Hosts Distributor SQL 2008 DB Engine Hosting
SQL 2008 Database Engine Hosts Publisher SQL 2008 DB Engine Hosting
SQL 2008 Database Engine Hosts Subscriber SQL 2008 DB Engine Hosting
SQL Database Engine Hosts SQL Database SQL DB Engine Hosting
Entity Watched By Perspective Entity Reference

Health Target
NameClassType
SQL Server 2008 Instance Group Contains Instances SQL 2008 DB Engine Membership
SQL Server 2008 R2 Instance Group Contains Instances SQL 2008 DB Engine Membership
Instance Group Contains All Instances of SQL DBEngine SQL DB Engine Membership
Windows Computer Hosts Windows Computer Role Relationship Type 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 Management Pack


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