Undertaking a server health check is never a bad idea. However, in realit, how often do you get the time to carry out a thorough inspection of your SQL Server environment? With a never-ending list of priorities, whether it is moving to Azure or fighting to get a database back online, a health check rarely makes it on to the ‘to-do’ section of the scrum board. If it does, it probably sits there until the stickiness of the post-it note dries out and it drops to the floor.
At the same time, rarely do you encounter IT Managers or CIOs who can honestly say they have 100% confidence in their databases. That may be normal but how would you feel if you went to a dentist, doctor or physiotherapist who wasn’t 100% confident? It would be a concern to say the least.
Measuring how confident you feel is clearly subjective, so how do you know when you really need a SQL Server Healthcheck? Here are 6 tell-tale signs:
- You’re suffering the effects of poor performance
Have you noticed that the time it takes to run a query has slowly but surely increased? Are your users complaining about applications crashing or running slow? Do you and your team talk about ‘the good ol’days’ when everything ran faster? Poor performance is not fun, don’t let it continue.
- You need more hardware
This could well be the case but don’t jump to conclusions. ‘We need more hardware’ is one of the most common misconceptions we hear. A health check almost always uncovers opportunities for optimisation. Streamline your environment and reduce the need for expensive infrastructure.
- Your team doesn’t have time for innovation
If your team are fighting to keep the lights on, it’s a good chance there’s something wrong. A health check will help you uncover what you don’t already know and help you develop a failsafe plan to tackle the problem areas.
- You haven’t implemented a Service Pack or Cumulative Update recently
If a Service Pack has been released in the last 3 months and you haven’t implemented it yet, it’s safe to say your databases are at risk. Services Packs and Cumulative Updates should be a high priority for any DBA. If these are getting put on the backburner, chances are your technical debt is building up.
- You (or your DBA) are new to the job
It usually takes a good 6 months, sometimes years to fully understand your environment. A health check will fast track the time it takes for you to get to know your servers and all their quirks
- You’ve experienced an outage in the last 3 months
Outages happen. You may have found the root cause this time round but it’s likely you’ve got another 5 waiting to occur. A health check will help you identify the risks before they become issues.
Get a SQL Server Health Check with MOQdigital today.
If you are experiencing any of the above, MOQdigital offer SQL Server Database Health Checks that will help you improve ROI if you are experiencing 2 or more of the above. If you would like to learn more, please reach out to us.