Have Confidence in Your SQL Databases
With Microsoft releasing a new version of SQL Server almost every year and service packs or cumulative updates on a monthly basis, it’s easy to fall behind. Database performance reflects business performance. Don’t wait for your database to fail before you act. Our SQL Server Healthcheck will help you pinpoint the cause of issues and identify opportunities to increase efficiency and reduce costs.
During a Healthcheck, our Data Platform architects carry out a comprehensive examination of your Microsoft SQL Server environment. We’ll highlight areas of concern and provide actionable recommendations to improve the performance and availability of your Microsoft SQL Server infrastructure.
HOW DOES THE SQL SERVER HEALTHCHECK HELP?
Have confidence in your SQL Server Databases
Minimise the chances of failure
Discover what you don’t know already
WHAT’S INVOLVED IN A SQL SERVER HEALTHCHECK?
We meet with your team to discuss your concerns and any current issues. This could be anything from a slow running process or security reservations to upcoming audit, government or regulatory requirements. We will walk you through the approach we plan to take and organise the access levels required for carrying out the SQL Server Database Healthcheck.
Running the checks to determine the health of your database
Our SQL Server Healthcheck is a holistic review of the health of your SQL Server environment, referencing Microsoft and industry best practice. We assess configurations at both an operating system and server level. As we are running our checks, we collect data about your databases, instances, and server and compare our findings to your expectations and industry standards. We analyse areas such as CPU usage, memory and disk performance. View the full list of checks we run.
SQL Server Healthcheck Report & Workplan
We summarise our findings in a comprehensive written report, prioritising concerns and detailing our recommendations for resolving the issues. We take your team through the report and provide you with an actionable workplan for any remediation work required. Download an example Healthcheck report and Workplan here.
WHAT WE LOOK FOR IN OUR SQL SERVER HEALTHCHECK:
Server and Operating System Configurations
- Disk volume configuration
- Swap file configuration
- Local Security Policy
- User Rights Assignment
SQL Server Instance Configurations
- Default collation
- CPU and Memory Configuration
- SQL Server level security analysis
- Maintenance plan and backup job review
- Trace Flags
- Database options, file sizing, file placement
Database performance and schema review
- Index fragmentation
- Blocking and deadlock detection
- Query performance review
SQL Server resource utilisation bottleneck review
- Server level performance (CPU, Memory, IO, Networks, Storage Capacity)
- SQL Server internal resource utilisation (Buffer Utilisation, IO Performance, Waits)
- Windows event logs
- SQL Server Error logs
- Agent logs
Database deep dives:
- Query execution plan analysis
- Schema, table and index analysis
Application Database Review:
- Defining all primary keys and foreign key relationships
- Identify appropriate data types
- Normalisation, renormalisation and more…
WHAT OUR CUSTOMERS SAY
Following WARDY IT Solutions’ SQL Server Healthcheck, we were able to reduce our database tier to a lower level, while bettering the service to our users.
Ryan Hilton, Web Application Developer Timing Solutions
The SQL Server Database Healthcheck provided by WARDY IT Solutions was invaluable. The level of detail that the findings went into was truly remarkable. By implementing the changes recommended by the Healthcheck we were able improve the performance of our SQL Server instance by over 160%.
Cherie Whelan, RPS Group