What is the goal of a SQL Server Health Check and how it can help your IT Environment

Jason Timm / December 02, 2016
What is the goal of a SQL Server Health Check and how it can help your IT Environment

What does your data mean to you?  Can you open your doors for business tomorrow if your data is suddenly gone?  Will your company be prepared for the possibility of your data being unavailable for some period of time?  If your data is corrupt or lost due to a disaster situation, how will you handle this situation?  If you are not treating your data as the asset that it is, the first step to being able to answer these questions is an immediate analysis of your data environment. 
A SQL Server Health Check is the process of analyzing your data environments, checking for consistency, performance, recoverability, and overall stability.  If you are not intimately aware of the health of your data environment, you are not alone.  Companies, large and small, consider their data environments as stable because they haven’t yet experienced an outage.  The truth is, without regular maintenance and routine health checks, your good luck to date will eventually turn into a miserable, exhaustive, and expensive exercise in rebuilding.
What is the goal of a SQL Server Health Check?

  • Validate the architecture, database design, and platform

  • Determine problematic code that is causing slow-downs, locking, blocking and frustrated users

  • Identify systemic issues and misconfigurations

  • Adhere to the Microsoft and industry accepted best practices for development, maintenance, and recovery

  • Prepare for upgrades of SQL Server, Windows, Storage

  • Outline considerations when moving to the cloud, virtualization or new hardware

  • Enumerate operational issues impacting the business and spinning wheels of team members

  • Identify roadblocks to capacity and scalability issues

  • Ensure your SQL Server environment is properly secured and your customers are protected

  • Score your data environment against the four (4) pillars of a health environment (Stability, Reliability, Scalability, and Recoverability)

Heartland Business Systems (HBS) has invested heavily in building a comprehensive and complete process that can be run against your environment.  This process has been developed by our highly trained, skilled, and experienced team of Database Administrators (DBAs).  Our DBAs can work with you to identify the problems areas and as a deliverable, present the findings of the Health Check in a very clear, concise, and consumable fashion.  Our internal goal is to describe the issues in a way that you do not need to be a seasoned DBA to understand.  Additionally, we provide you with an estimate of what it will take to remediate the issues and improve your overall health score card.  The most important message I can share with you is not to take the health of your data environment for granted. 

Jason Timm
About the Author

Jason Timm
Solutions Architect

Jason has been working in the IT industry for over 20 years. He is a highly experienced, and dynamic IT Professional with extensive experience in database administration, data warehouse design, business analysis, business intelligence, project management, and IT leadership. Jason directs the Data team at Heartland and is also responsible for new product development, product enhancement, process improvement, staff development, strategy implementation, and mentoring.

Blog post currently doesn't have any comments.