Performance ● Support ● Availability Microsoft SQL Server Health Checks
Comprehensive SQL server instance health checks from $2,750.
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.
PERFORMANCE BASELINE
We track and analyse over 100 SQL Server and Operating Systems performance counters to identify any potential infrastructure based bottlenecks.
OPERATING SYSTEM
Disks, network, CPU, memory and operating system settings which can impact on how SQL Server interacts with its host environment.
SQL COMPONENTS
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.
CRITICAL DATABASES
Identify high value missing indexes, duplicate or unused indexes which create performance overheads and other DB internal misconfigurations.
RECOMMENDATIONS
Receive a detailed report akin to a Microsoft SQL RAP, containing all findings and recommendations.
Why Clients Work WIth Us
Contact Us
We typically respond within minutes.