WHY IS A SQL SERVER PERFORMANCE REVIEW IMPORTANT?
SQL Server and any associated databases are complex software and can quickly deteriorate in performance for many reasons such as inefficient code, SQL mis-configuration, network latency or I/O stalls.

Without having an in-house DBA or database specialist, it can be almost impossible to identify the source of performance issues.

Improving or updating a database management system is not just a maintenance task, but an opportunity to derive new business value.

What’s Included?
The SQL Server estate will be investigated in order to ascertain suitability for purpose as well as to identify areas for improvement, both in technical and performance terms. This includes checking:

  • Basic performance measures for the server are on line (CPU, Memory, IO)
  • Databases are performing adequately with respect to I/O
  • Instances are correctly configured for workload type
  • Any obvious badly performing queries
  • Number of concurrent users
  • Table and Row locking considerations
  • Index tuning and maintenance analysis
  • Storage Configuration
  • Appropriate database configuration
  • File placement analysis
  • Collation sequences
  • Size and growth management
  • Partitioning (tables and views)

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

This service scales to thousands of servers and is design to accelerate projects to reach the point of migration as quickly as possible.

WHAT'S NEXT?
By carrying out the SQL Server Performance Review service customers are provided with an indicative costs, risk and impact analysis to help you with 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
Read more.
Micro Focus Ltd
“The expertise and efficiency Systems Assurance apply to their projects is a lesson many dealers could learn from.” Senior Buyer,
Read more.
Room Automation AMX
AJS V.o.F.
“The project was well executed; at no time did I find either cost spiralling or dates being pushed back. They
Read more.
Bradford Grammar School
“Systems Assurance found the best solution for us, by communicating on a regular basis and knowing exactly what we required.”
Read more.
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[...]