SQL Server Health Checks Identify Mis-configurations and Problem Conditions before the Impact your Business.
Misconfigured SQL servers can have a significant impact on the performance, reliability, availability and recoverability of your business’ core database infrastructure. Given the high cost of SQL Server licensing, it’s always impressed us to find how many businesses fail to properly configure SQL Server to maximise the return on their investment!
Our SQL Server Health Check service conducts a detailed review of your SQL Server infrastructure, akin to a Microsoft SQL RAP (although we’d argue ours is even more detailed), which looks at everything from the hardware layer including disks, CPU, memory and network, up through the OS configuration and into SQL Server itself and even into specific problem databases.
For clients who have elected to perform our SQL Health check as part of our Managed SQL Server on boarding process, we’ll also incorporate remediation activities as part of our health check.
48 hours Performance Baseline Analysis
Review of Storage, Network, CPU and Memory Configurations
Detailed assessment of SQL Server Instance components including services configuration, maintenance plans, failure notifications and SQL operators, high availability configurations and more!
Critical business database reviews for misconfigurations including identification of any high value missing indexes, duplicate indexing, heap tables and much more.
We track and analyse over 100 SQL Server and Operating Systems performance counters to identify any potential infrastructure based bottlenecks.
Disks, network, CPU, memory and operating system settings which can impact on how SQL Server interacts with its host environment.
Review of multiple instance configurations and environments which host multiple components such as SSRS, SSAS.
SQL INSTANCE CONFIGURATION
Deep dive assessment of SQL Server’s instance components including core SQL build elements to ensure the installation has been comprehensively installed and configured.
Identify high value missing indexes, duplicate or unused indexes which create performance overheads and other DB internal misconfigurations.
Receive a detailed report akin to a Microsoft SQL RAP, containing all findings and recommendations.
Why Clients Work WIth Us
We typically respond within minutes.