SQL Server Database Healthcheck

Have Confidence in Your SQL Databases
Identify SQL Server Database Issues and Causes

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

Rest easy knowing your data is safe, secure and performing optimally.

Minimise the chances of failure

Reduce the business risks associated with down-time, performance bottlenecks and the complexities of deploying and managing Microsoft SQL Server.

Discover what you don’t know already

Know where there’s room for improvement and have a failsafe plan to tackle the risks.

WHAT’S INVOLVED IN A SQL SERVER HEALTHCHECK?

Discovery

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
Introduction to SQL Databases

Database Configurations

    • Collation
    • 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)

Log reviews

    • Windows event logs
    • SQL Server Error logs
    • Agent logs

OPTIONAL:

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

 

Timing Solutions

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

RPS logo

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

GET IN TOUCH:



From the Library