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