SQL Database Information service
When this service has a scan interval of less than 5 minutes, the agent may take longer than the scan interval to gather the metrics. As a result, you may notice some scan intervals are not populated.
The SQL Database Information service monitors information about an SQL database including file sizes and transaction rates.
Service Type | WMI |
Instances on a Device | 15 |
Supported Systems/Applications | Microsoft SQL Server |
Device Class | Server - Generic, Workstation - Generic, Laptop - Windows, Server - Windows, and Workstation - Windows |
Monitored By | Windows agent |
Scan Interval | 15 minutes |
Minimum Scan Interval | 1 minute |
SQL Server Instance | The specific instance of the SQL Server database engine that is running on the target server. |
Database Name | The name of the monitored SQL database. |
Status Detail | Description |
---|---|
Log Files Size (KB) | The current size of the transaction log for the database that is being monitored. |
Transactions per second (Transactions/Second) | The number of database operations/transactions performed per second. |
Data Files Size (KB) | The current size of the data file for the monitored database. |