SQL Governor® – the leading-edge software for Microsoft SQL Server optimization

SQL Governor for planning, forecasting, and optimizing Microsoft Data Platforms

SQL Governor is the only software product in the market that offers performance monitoring, optimization, and capacity planning in the same solution. SQL Governor’s features for future-proofing the data platform include proactive monitoring and alerting, SQL Query tracing, diagnostics and health checks, capacity management, and planning the future capacity of the platform. In addition, the rich reporting capabilities complement all the above mentioned features.

SQL Governor's agentless architecture makes it secure, robust, and scalable for large SQL Server environments. It can collect data simultaneously from all the servers with minimum performance footprint. In addition, the solution takes into account the various data security requirements of large data centers.

Request a free demo

MONITORING

patterns alerts 3

SQL Governor software allows you to monitor the platform 24/7 from a rooftop view and drill down to server, instance, database, and SQL Query levels to effectively identify the root cause of performance problems. SQL Governor supports over 60 different performance counters to give you all the information you need. 

You can follow key performance counters, alerts, and corresponding predictive alerts on server, instance, and database level. You can identify bottlenecks in hardware, OS, DBMS instance, and database level by following the performance counters and a variety of different kinds of reactive and proactive alerts. Thanks to the predictive alerting features, you can prevent problems from happening even before they occur.

WARNINGS & ALERTS

eka (2)

Set your own alert and warning levels and get alerts to your e-mail. Manually or automatically configure alert levels and actions for each performance counter – and even each individual server, instance and database. Prevent platform disasters and minimize downtime with different kind of predictive alerts – SQL Governor gives you the ability to foresee potential problems up to one day in advance, allowing you to eliminate unwanted surprises before things get out of hand.

  • Every combination of server/instance/database and performance counter is configurable for both warnings and alerts
  • Option to receive emails and dashboard notifications for actual and/or predicted alerts
  • Manually adjustable basic alerting
  • Auto-adjustable warning & alert levels based on historical data
  • Service Level based alerts
  • Continuous alerts
  • Predictive alerts based on linear regression
  • Pattern-oriented alerts based on machine learning
  • Anomaly detection over time dimension

SQL QUERY TRACING

SQL Query Tracing in SQL Governor

Get detailed profiling data by configuring, running and diagnosing lightweight traces from TSQL queries running on client SQL Servers. Trace data allows you to identify which queries are using the most resources and when.

With SQL Governor, you can launch light-weight TSQL query traces on desired databases. This way you can identify poorly performing TSQL queries.

DIAGNOSTICS & HEALTH CHECK

healthcheck

It is not uncommon that SQL Server instance level configurations and database options are not in optimal level. The diagnostics functionality in SQL Governor helps to pinpoint the pain points in these configurations.

With SQL Governor, you can automate your diagnostics process regarding client SQL Server wait statistics, indexes, instances, databases, and more. Identify unused indexes and the most critical missing and fragmented indexes to focus on the essential. Run instance and database level health checks on your production environment to keep your fingers on the pulse at all times.

  • Database options health check
  • Instance configuration properties health check
  • Missing indexes
  • Unused indexes
  • Fragmented indexes
  • Wait statistics

 

CAPACITY MANAGEMENT

SLAS

Do you know how well your server capacity is meeting the utilization needs, both now and in the future?

SQL Governor makes it possible to understand that for how long in the future the system will have enough resources.

The capacity management features allow you to monitor that the capacity limits of the platform are not exceeded at any time during the life cycle.  Set service-level agreements for the performance counters you want to. Connect servers, instances and databases to services and customers to manage your whole SQL Server platform with minimal effort.

CAPACITY PLANNING

Planning - Target server topology

Typically, planning the future capacity for SQL Servers in migration or consolidation situations is a very hard and complicated process. SQL Governor automates and streamlines this process with international patent pending technology. It makes the software unique in the market as it has the ability to plan the future of the SQL estate.

SQL Governor calculates the optimal server configuration for your target data platform, resulting in remarkable cost savings and a more robust target architecture. SQL Governor supports both server-level and instance-level capacity planning, in addition to server right-sizing. In server-level planning, existing physical servers are virtualized under a new physical server to increase performance and reduce licensing costs. In instance-level planning, existing SQL Server instances are automatically organized into an optimal architecture.

DASHBOARD

dashboard (002)-1

This feature in SQL Governor gives you an automatically updated, real-time overview of the health of the entire system at once, perfect for displaying on a large screen. The dashboard view covers most important alerts, predicted alerts, physical volume tracking, TSQL query plan cache situation and blocked queries.

REPORTING

heatmap-(2019)SQL Governor's rich reporting capabilities complement all the above mentioned features. In addition, all of the performance data in SQL Governor is permanently stored into a data mart, which means that historical data is always available for querying. Use the versatile built-in reports to find the information you need and share it with others by exporting to PDF or Excel. SQL Governor comes with more than 30 built-in SSRS reports.

 

Banner Image

 

SQL Governor's patent-pending method for instance-level consolidation planning explained

 

 

 

SQL Server capacity planning, predictive monitoring and performance optimization