Features
MS SQL Monitoring
SQL Server Memory Details
Granted Workspace Memory
Total amount of memory currently granted for executing processes such as hash, sort, bulk copy, and index creation operations.
Maximum Workspace Memory
Maximum amount of memory available for executing processes
Optimizer Memory
Total amount of dynamic memory the server is using for query optimization.
SQL Cache Memory
Total amount of dynamic memory the server is using for the dynamic SQL cache.
Target Server Memory
Total amount of dynamic memory the server can consume.
Total Server Memory
The committed memory from the buffer pool.
Locks and Latches details
Deadlocks per second
Number of lock requests per second that resulted in deadlock. This value should be zero.
Lock Waits per second
Number of lock requests per second that require caller to wait.
Latch Waits per second
Number of latch requests that could not be granted immediately.
Average Latch Wait time
Average latch wait time for latch requests that had to wait.
SQL Server Database Details
Active Transactions
Number of Active Transactions for the database.
Database Size
Cumulative size of all data files in the database.
Log files used
Percentage of space in the log that is in use.
Log cache Hit ratio
Percentage of Log cache reads satisfied from the log cache.
Transactions per second
Number of transactions started for the database per second.
