GSX Blog

Get a comprehensive view on how SQL Server is performing?

Posted by Olivier Raynaut on Thu, Jan 28, 2016

Screen_Shot_2016-01-28_at_11.45.25_AM.pngWe’re pleased to announce that the comprehensive monitoring capabilities of GSX Monitor is now available for Microsoft SQL Server!

SQL is the standard language for relational database management systems. SQL statements are used to perform critical tasks, such as updating or retrieving information from the database. GSX now monitors Microsoft SQL Server, one of the most common relational database management systems based on SQL.

Properly monitoring your SQL Server will allow you to identify performance trends and determine if key changes are necessary to optimize performance.

Why it is important to monitor Microsoft SQL Server?

Monitoring your SQL Server is critical because it provides a service within a dynamic environment. Many components of the environment may change, from the data in applications to the types of user access to the ways in which users connect to the database. The types of applications accessing the SQL Server may also change, though it will automatically manage system-level resources including memory and disk space.

While many enterprises choose to monitor their SQL environments manually by scheduling jobs and creating alerts, this is a really long and complex process that requires a SQL expert to manage. In addition, these configurations are occurring in SQL, so if any of the SQL critical services experience issues, at risk.

Moreover, as the SQL backend is used by multiple applications, manual monitoring prevents other teams from understanding SQL environment issues. There’s no ability to have a shared, centralized dashboard, so you can’t share knowledge about SQL health across teams. This will likely result in performance and health issues that impact the global performance of applications relying on SQL, and therefore the service delivered to end users will be disrupted with little visibility into why or how.

How does GSX handle SQL Server Monitoring?

With GSX for SQL Server, IT administrators can monitor and troubleshoot the SQL backend in real-time, as well as the applications utilizing the SQL Server.

SQLtooltip.png

In addition, administrators can monitor SQL Servers and databases from multiple locations to identify datacenter or local performance issues.

  • End-to-end Performance Monitoring: GSX connects to the SQL environment exactly as the front-end application would connect. This is not just monitoring for SQL, but dedicated end-to-end, front-end, and back-end application monitoring. A unique dashboard displays the real-time status of front-end application servers that are using SQL as a backend.
  • SQL Server Availability: GSX calculates the availability using query execution time, and allows you to easily visualize this 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: SQL database Engine, Server agent, distributed transaction coordinator, SQL server browser, SQL Server WSS writer.
    • Alert on Cluster Failover Monitoring: In case of a failover on your SQL clustered infrastructure, GSX will alert you in order to prevent dramatic high availability incidents.
  • Proactive Performance Monitoring: GSX enables proactive performance monitoring by measuring key performance indicators and alerting you to any degradations.

    SQL_Health_and_performance_.png
  • System Performance: GSX will help you 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: 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 and be alerted when the % of pages found in the cache buffer starts to be below a certain level
    • Lazy writes per second must stay low, otherwise it indicates that you start to have too many dirty pages.
    • Pages reads and writes per second You need to know how many times the disk access has been made by the SQL server as too much disk access can spot a cache issue and will decrease SQL performance.
  • Full Scan Per Second: The full scan is an automatic process that is critical to the health of the SQL database and that is run when needed by the infrastructure. GSX constantly looks at this counter and alerts you as soon as an unexpected high number of full scans occurs.
  • Queries Optimization: GSX detects queries that impact overall performance by creating bottlenecks and overloading the cache.
    • Average wait time: GSX enables you to make sure that the average wait time stays low, preventing performance issues
    • Poor performance SQL queries: GSX constantly reports on the SQL server queries in the cache for optimization
    • Dead Locks: high number of dead locks is a good indicator of issues regarding SQL access & queries so GSX allows you to be proactively alerted.

All these metrics collected by the GSX provide a clear view on the status of the applications that are using SQL. 

SQL_Graph.png

Benefits of monitoring SQL Server

GSX’s powerful, dynamic alerting and reporting capabilities can be customized to suit your organization’s needs. Our real-time dashboard can be shared across multiple teams in multiple locations, giving everybody key insights into the SQL back-end as well as front-end application servers. Proactive SQL administration means that you will be empowered to understand and predict overall usage to adjust resource allocation, reduce Mean Time To Repair and help desk calls, and ultimately save a lot of time and money.

Screen_Shot_2016-01-28_at_11.58.33_AM-1.png

Contact us for more information >> 

 

 

 

 

Tags: sql server, Connectors, SQL Applications, Monitoring SQL server