• Active Directory
  • Application
  • Desktop & Mobile
  • Help Desk
  • Network
  • IT Security
  • MSP
  • On-Demand
 
 
Device Management, made easy
Manage control and secure your workstations, mobile
devices and tablets
 
 
Help Desk for Everyone
IT Help Desk Software and Customer Support Software
 
 
Protect Your IT. Save Your Business
Build a secure fortress with our security management solutions
 
 
MSP
Manage services faster, with multi-tenanted, ITIL-ready, and unified RMM solutions
 
 
On-Demand Solutions
IT Help Desk, Active Directory, and Operations Management from the Cloud
 

SQL Health Monitor - Features

SQL Server Memory Details

Granted/Maximum Workspace Memory

Total amount of memory currently granted for executing processes such as hash, sort, bulk copy, and index creation operations. Also view maximum amount of memory available for executing processes.

Optimizer/SQL Cache Memory

View the total amount of dynamic memory the server is using for query optimization/ dynamic SQL cache.

Target/Total Server Memory

Target server memory is the total amount of dynamic memory the server can consume and Total server memory is 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 requests the 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.