SQL Server health check

What’s involved in a WellData health check?

Developed over a number of years, our most experienced consultants at WellData have created a thorough and concise structure for reviewing and health checking SQL Server databases. Many companies use this service regularly to help keep an eye on things, whilst others simply get in touch when they suspect operational issues. Our health check flags up minor issues before they become major defects, giving our clients complete peace of mind.

The aim of a WellData health check is to identify any risks to availability, recoverability, performance or security of the SQL server through investigating non-compliance, configuration issues and monitoring issues. Each aspect is investigated and reported on, and each health check includes an analysis section which provides the results of our investigations. Analysis includes the severity of any problems found and also a course of remedial actions which either your in house team, or us, can implement and resolve.

Health check methodology

Our teams have developed a number of scripts which effectively test your SQL server. These scripts are a combination/hybrid of T-SQL and PowerShell. They are run against a provided list of SQL Servers and collect data on all aspects on configuration, performance and usage.

  • Performance
  • Security
  • Reliability

Health check results

The results from these scripts are then reviewed by our analysts. These three elements are then graded according to severity, and are attributed one of three categories

  • Critical
  • Warning
  • Informational

Health check report

When the results are fully reported and understood, a summary is written which details the most important results. Typically, these health checks flag up such things as absence of backups, disk latency and irregular and incomplete maintenance schedules.

The completed report is sent to you, and the analyst responsible for carrying out the health check and creating the report will call at a time which suits you – to run through the health check with you and answer any questions you may have.

SQL Server health checks are available as a one off service, or are included in our comprehensive SQL Server database support contracts.

 

Get in touch

Here's what other people think

Andy Cole
Andy Cole
11:45 06 Nov 18
Really know their stuff and their response times are very good.
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
John Lynes
John Lynes
14:00 04 Oct 17
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more