A major Health Department was running a data system that has been expanding over the years. Eventually, they ended up with a highly outdated and inefficient environment with thousands ...
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.
Check out our customer story blog posts on how we helped our customers with SQL Server Health Checks.
One of the largest transportation authorities was running the mission-critical system on SQL Server platform and any down times could harmfully affect on their business. So, they deci...
One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the...
DBMSys is a lightweight tool designed by DB Best specifically around collecting data from multiple environments to help develop a business case for a modernization to upgrade path. The...