WHY IS A SQL SERVER HEALTH CHECK IMPORTANT?

With any system it is important to regularly assess that it is fit for purpose and with SQL Server this includes key areas that every Instance should have configured appropriately:

  • Security
  • Performance
  • Best practice configuration
  • Scalability
  • High Availability and Disaster Recovery SLA (Service Level Agreement) compliance
  • Maintenance (log management, index management, growth mechanics)

What’s Included?
An initial briefing to understand the purpose of the system and any potential areas for concern.
A custom health check program to investigate and assess with respect to system requirements and best practice:

  • Database Sizes
  • Database Disk locations, types and sizes
  • Memory settings and utilisation
  • Number of CPUs and configuration within SQL
  • Database Maintenance and fragmentation
  • Security Settings
  • SQL Configuration Settings
  • Disaster Recovery (DR) Provision
  • High Availability (HA) Provision
  • Correct use of Indexes

The output will be a report detailing:

  • Environment configuration details
  • Configuration against best practice
  • Recommendations for any remedial action and improvements

WHAT’S NOT INCLUDED?
The health-check itself does not include any remedial work and is intended for the sole purpose of investigation, reporting and recommendation.

COSTS
Single instance of SQL Server (non-clustered or two node cluster) - 2 days
Multiple SQL Server instances (non-clustered or two node cluster) - 2 days plus 0.5 days per each additional instance

WHAT'S NEXT?
By carrying out the SQL Server Health Check service customers are provided with an indicative cost, risk and impact analysis to quickly decide the actual migration, planning and deployment phases.

Why not have a quick chat with a member of our pre-sales team to find out if this is suitable for your business - 0114 292 2911 or drop us an email.

DavyMarkham
DavyMarkham
"Systems Assurance spent time getting to know our systems and culture before suggesting a way forward. Thank You!" Peter Herbert,
Hydro-X
Hydro-X Water
They delivered a first-class service. Systems were knowledgeable and really helpful, getting to know our processes beforehand. Matt Bell, IT
Consort Server Project
Consort Windows
Using Systems for years, why look outside when you can use someone you trust and who have never let us
Gripple Ltd
"With the right balance of technical ability and user experience - they were just what I needed to deliver the
3 Essential Power Automate Templates for Remote Workers
3 Essential Power Automate Templates for Remote Workers COVID-19 has fundamentally changed the way we think about the workplace.  Throughout[...]
Read More 
Say goodbye to passwords! How to enable FIDO2 passwordless authentication.
​​​​​Say goodbye to passwords! How to enable FIDO2 passwordless authentication. We’ve all heard the advice: choose a long, complicated password[...]
Read More 
Pointless Meetings Waste £45 Billion Every Year. 6 Ways to Stop the Meeting Madness.
Pointless Meetings Waste £45 Billion Every Year. 6 Ways to Stop the Meeting Madness. Think back to all the meetings[...]
Read More 
Don’t get locked out. Creating an emergency break glass account for Office 365.
Don’t get locked out. Creating an emergency break glass account for Office 365. Don’t get locked out of your Office[...]
Read More 
Reduce help desk calls by 50%. How to enable Self Service Password Reset.
Reduce help desk calls by 50% - How to enable Self Service Password ResetImagine the scenario: your employee is scrambling to[...]
Read More 
Artificial Intelligence. The Key to Reducing Workplace Distractions.
Artificial Intelligence. The Key to Reducing Workplace Distractions. Do you want to boost staff productivity by 50%?  According to Gloria[...]
Read More