SQL Server health check

What’s involved in a SQL Server health check?

Developed over a number of years, our most experienced SQL Server consultants have created a thorough and concise structure for reviewing and health checking SQL Server databases. Our SQL Server health check can be used to keep an eye on SQL instances and performance, or when operational issues are suspected. A SQL Server health check flags up minor issues before they become major defects, giving users complete peace of mind.

Health checks identify any risks to the availability, recoverability, performance or security of a SQL Server instance by investigating database health, configuration, monitoring and compliance issues.

Every aspect is investigated and reported on, and health checks include data and analysis of 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. This can be carried out as a stand alone, ad hoc health check, or as part of our SQL Server support service.

Health check methodology

Our team has developed a number of scripts which effectively and thoroughly test every SQL Server instance. These scripts are a combination/hybrid of T-SQL and PowerShell and are run against a set SQL Server list. Health checks collect data on all aspects of configuration, performance, space and usage.

  • Performance
  • Security
  • Reliability

Health check results

The results, data and any issues the SQL Server health check highlights are then reviewed by our analysts. The elements are graded according to severity and are attributed to 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 SQL Server health 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. Users are made aware of any actions required and can carry out remedial works in-house, or employ our SQL DBAs.

SQL Server health checks are available as a one-off service, or are included in our comprehensive SQL Server database services contract.

 

Get in touch

Here's what other people think

Google Rating
5.0
High standard, professional service. I've worked with Welldata for a number of years and always found their DBA's to be knowledgeable and proactive. Throw any question at them and it will be resolved, it gives real peace of mind knowing you have a partner you can rely on from emergencies to general questions. They also like a challenge and we do throw a few curved balls at them.read more
Paul Miller
Paul Miller
12:34 27 Aug 21
The support I receive from Well Data is extremely responsive. Richard Parsons is my contact and keeps me informed daily on the health of our SQL Databases. Whenever I ask for assistance from Well Data it is quick and professional.read more
Kay Riley
Kay Riley
13:41 19 Aug 21
Really know their stuff and their response times are very good. They provide us with a vital service.
Andy Cole
Andy Cole
13:36 19 Aug 21
The guys at WellData really know their stuff. We wanted a quick route to doing something complex and they sorted it for us very quickly and to a high standard. Very professional, no ego, just excellent and to the point consultancy.read more
Steve Goacher
Steve Goacher
11:31 14 Nov 19
I have worked with the WellData team for many years now and they have always delivered.I would highly recommend them to any business looking for best-value outsourced Expert DBA’s.Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment.Their professionalism and knowledge is second to none.read more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 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
Steve Fenton
Steve Fenton
10:56 05 Nov 18
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
John Lynes
John Lynes
14:00 04 Oct 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
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17