Our SQL Server Health Check is designed to ensure you get the most out of your database environments. We’ll take a deep-dive into your SQL Server configuration, infrastructure and workload, including:
Our SQL Server Health Check can be flexed to suit the specific requirements of your business. However, we typically follow the process outlined below.
Our team of experienced, Microsoft-certified DBAs will meet with you, either in person or remotely, to discuss your SQL Server infrastructure in detail before we carry out the SQL Server Health Check. We’ll establish and understand:
We’ll take a deep-dive into the setup, configurate and performance of your SQL Servers to find out both what’s working well, and where improvements are needed. Please see the FAQ section below for further details on the information that we look at as part of this service.
In addition to any changes implemented during the SQL Server Health Check, we will also provide a full report detailing our findings and the proposed actions. This will include details of our short, medium, and long-term recommendations.
Once we’ve submitted the report of our findings for your review, we’ll work with you to prioritise the list of actions that we provided during the collect and analyse stage. We will then plan the implementation of the changes, working closely with your team (if applicable).
We can either implement the actions that we have suggested ourselves, or support your existing team in doing so. We’ll understand your SQL Server infrastructure, and can tailor the implementation around your priority workloads.
You need a SQL Server Health Check if:
As part of your SQL Server Health Check, we’ll take a deep-dive into your SQL Server and collect and analyse the following information:
Koderly is a Microsoft Gold Partner, and we’ve been providing database services and software solutions to enterprise-level organisations for the past 20 years. Our market-leading travel software is powered by Microsoft SQL Server, and that has enabled us to build up a wealth of experience in administrating and tuning SQL Server environments, where performance and scalability are critical.
Our SQL Server Health Check will take a deep-dive into your databases and identify optimisation opportunities, whilst our Database Administration service will help to ensure your databases remain performant and in good health!