Microsoft SQL Server Health Check Systems Assurance Ltd IT Solutions for Corporate & Government Organisations

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.

Gripple Ltd

“They have the right balance of technical ability and user experience knowledge – they were just what I needed to

Micro Focus Ltd

“The expertise and efficiency Systems Assurance apply to their projects is a lesson many dealers could learn from.” Senior Buyer,

AJS V.o.F.

“The project was well executed; at no time did I find either cost spiralling or dates being pushed back. They

Bradford Grammar School

“Systems Assurance found the best solution for us, by communicating on a regular basis and knowing exactly what we required.”

1 2 3 Next »

Common Malware Threats, And How to Mitigate Them

Common cyber-security attacks, how to spot them and preventative measures Cyber attacks appear in many guises and recognising the most[...]

Four Steps to Preventing Cyber Attacks

Over the last ten years, Cyber Security threats have increasingly become a major problem for all organisations. Rather worryingly, the[...]

10 problems Office 365 can solve right now?

Whether you have 5 or 5,000 users, you need affordable and professional IT tools. Microsoft Office 365 gives you and[...]

Thinking about the cloud?you should be thinking about Azure…

Is it time to wave a final goodbye to those dusty, energy-consuming old servers? The requirement for their own dedicated[...]

Enable users to sync SharePoint with OneDrive sync client!

Follow these steps if you want to preview the syncing of SharePoint Online files before enabling the feature for your[...]

Why your organisation needs to be Cyber Essentials Certified

New research released in 2017 shows that over half of all UK companies experienced a Cyber-attack in 2016, costing businesses[...]