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

SQL Server 2008 DB Log File Class

  • ID:  Microsoft.SQLServer.2008.DBLogFile
  • Description:  Microsoft SQL Server 2008 database log file
  • Class Hierarchy: 
    Object
    Configuration Item
    Logical Entity
    Application Component
    Windows Application Component
    [Deprecated] SQL Component
    SQL DB File
    SQL Server 2008 DB Log File

  • 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. 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. 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. 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. 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. 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. Monitors the space available on a log file and on the media hosting the log in percentage terms. 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. This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes. Disk Read Latency monitor for 2008 Databases.  Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Disk Write Latency monitor for 2008 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. This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes. Disk Read Latency monitor for 2008 Databases.  Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Disk Write Latency monitor for 2008 Databases.  Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Microsoft SQL Server 2008 database log file Microsoft SQL Server 2008 database Microsoft SQL Server 2008 Mirrored Database

Download diagram as a Visio file

Properties

Display Name Description
Asset Status Asset status
Display Name Display name of the object.
Drive  
File ID (Key)  
File Name  
File Path  
Notes Notes
Object Status Object status
Size (MB) (Deprecated)  

Discovered By

Name Description
Discover Files This object discovery discovers the file information for each SQL Server 2008 Database. The discovery is used in specific databases or DB Engine instances, where a deeper file monitoring is required.

Relations

Health Source
NameClassType
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 2008 Database Hosts Log File SQL Server 2008 DB Log File 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