call us toll-free +1 855 855 3600
 
Home > Services > SQL Server Health Check

SQL Server Health Check


Are your databases conforming to best practices to make sure they are highly available, secure, being backed up properly, and conforming to your organization's service level agreements? If you are not sure, check out our Health Checks offer.

Are you keeping up with the latest SQL Server health check rules?


Up until SQL Server 2012, Microsoft released versions of the SQL Server Best Practices Analyzer to help you identify potential issues with your SQL Server deployments. Since then, Microsoft stopped releasing the tool and expects you to deploy Microsoft System Center Operations Manager with the SQL Server Management Pack to test database servers and databases for best practice rules.

For many organizations, an additional investment in Microsoft System Center for managing databases is not cost effective. Instead, we see many of our customers run various scripts on a regular basis that test conditions that were known to be failure conditions based on prior service tickets. In many cases, the newer database administrators don’t even know what the script actually tests for.

Our SQL Server Health Check service addresses the following challenges that we hear from working with hundreds of customers each year.

Following the best practices

How can we be sure that we are following the best practices for SQL Server deployments?

Our team of Data Platform Most Valued Partners (SQL Server MVPs), Microsoft Certified Masters (MCM) for SQL Server, and SQL Server Database Administrations (DBA) who manage thousands of SQL Server deployments from customers have built a knowledge base of hundreds of rules for versions of SQL Server 2000 through SQL Server 2017.

We have incorporated these rules into our DBMsys platform to provide reports with suggested remedies for your SQL Server deployments.

Solving any monitoring challenges

The SQL Server Policy-Based Management system doesn't allow database administrators to create detailed rules that can be effectively run against our systems.

Our DBMsys platform incorporates all of the latest policy-based management rules that Microsoft provides for each SQL Server release. Since we’ve developed DBMsys for internal use, we can easily customize it to capture rules that look at the operating system, cluster configurations, disk subsystems, and other aspects of your SQL Server deployment that policy-based management can’t easily monitor.

Keeping your monitoring system up-to-date

We currently have our own scripts and utilities to check for best-practices, but it's an ongoing challenge to maintain the list for new versions of SQL Server and event new infrastructures like running on Microsoft Azure, AWS, or Google Cloud Platform.

As a certified partner for Microsoft, Amazon, and Google technologies, we keep up with all the latest best practices and incorporate them into our DBMsys platform. We have many customers that trust us to provide 24×7 monitoring of their systems for on-premises and cloud deployments, so we need to be current.

If you sign up for the managed version of SQL Server Health Checks, we can even customize DBMsys for you to also look at system metrics used by your application monitoring infrastructure.

What do we cover?


We have over 200 rules and growing that we cover as part of our standard SQL Server health check review with monthly updates to support the latest releases and infrastructure platforms. Here is a list of the metrics categories that we support to give you a sense of the depth of our health check monitoring.

Category

  • Availability

  • Best Practices

  • Blocking

  • Capacity planning

  • Constraints

  • Corruption

  • CPU

  • Database Objects

  • Database Settings

  • Deprecated Features

  • Design

  • Disk

  • Disk Settings

  • Encryption

  • Feature Usage

  • General

  • High Availability

  • Indexes

  • Instance Settings

  • IO

  • Jobs

  • Linked Servers

  • Logins

  • Logs

  • Machine Settings

  • Maintenance

  • Monitoring

  • Memory

  • OS Settings

  • Performance

  • Replication

  • Report

  • Security

  • Services

  • Statistics

  • System Health

  • Table Settings

  • Users