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. |