Get a comprehensive view of how SQL Server is performing, including the SQL backend and the applications utilizing the SQL Server.

GSX for SQL Server keeps IT admins on top of server and database health and performance issues with proactive agentless monitoring. Ensure continuous and secure operation of servers and databases from multiple locations.

Make sure your applications are not at risk while controlling server health, blocked queries, caches and network diagnostics.

The new GSX Gizmo is a powerful web-based dashboard that gives the IT team the information they need, at the time they need it. Read more >>

describe the imagerequestDemoGizmo-2.pngcta-whitepaper365health.png

  Beyond Unified Communications



  • leaderboard-gizmo2-1.png
  • Powerful real time dashboard: Benefit from a single dashboard that delivers all your SQL Server performance metrics from multiple locations to detect IT bottlenecks ahead of time. The dashboard displays the real-time status of front-end application servers that are using SQL as a backend.
  • End-to-end performance monitoring including SQL availability and performance, network diagnostics, and front-end applications.
  • End-user impacts including CPU & RAM usage, paging, queue length, cache overload, full scans per second, average wait time, and dead locks.
  • SQL Server Availability: GSX calculates the availability using query execution time, and allows IT Administrators to easily visualize these metrics using graphs to compare servers and databases, detect bottlenecks, and be proactive in troubleshooting performance issues.
  • Alert on Critical Windows Services: GSX monitors the critical SQL Windows Services on each Windows server including SQL Database Engine, Server agent, distributed transaction coordinator, SQL server browser, and SQL Server WSS writer.
  • Alert on Cluster Failover Monitoring: In the event of a failover on your SQL clustered infrastructure, GSX will alert you in order to prevent dramatic high availability incidents.
  • System Performance Monitoring: Keep track of anything that directly impacts SQL infrastructure performance, including CPU usage, RAM usage, paging-per-second, as well as disk time and queue length.
  • SQL Cache Monitoring: Cache monitoring is critical to prevent overload and critical failures. GSX allows you to prevent disk access rise and abnormal behavior of the cache by monitoring Cache hit ratio, lazy writes per second, pages read, and write per second.
  • Full Scan Per Second Monitoring: This is critical to determine the health of the SQL database. GSX constantly looks at this counter and alerts you as soon as an unexpected high number of full scans occurs.
  • Queries Optimization Monitoring: GSX detects queries that impact overall performance by creating bottlenecks and overloading the cache by tracking the average wait time, poor performance SQL queries, and dead locks.