What Are SQL Elements Health Checks?

by Sep 11, 2014

I have recently received a number of questions regarding Health Checks in SQL Elements, what are they, how often do they run, and what do I do with them? Health checks are a great way to get a holistic view of the performance, availability and other critical issues on SQL Server instances in your environment.  This is important information to have at your fingertips whether you are a novice or seasoned DBA.

In all, twelve metrics are tracked with data automatically collected at varying intervals. You can also manually refresh the data at any time with a few mouse clicks.
In all, twelve metrics are tracked with data automatically collected at varying intervals. You can also manually refresh the data at any time with a few mouse clicks.

So great, now I know that I have an issue with my database running out of space or DBCC CHECKDB hasn’t been run in a while…how exactly is that impacting me and what can or should I do about it? SQL Elements can help out there too, with in tool explanations of the problem to help put it into context and links to additional expert information on the web.

Expanded view of Health Checks recommendations in the SQL Elements Dashboard.
Expanded view of Health Checks recommendations in the SQL Elements Dashboard.

 

Elements online help
Each Health Check provides links to additional information online.

Have you been taking advantage of Elements Health Checks? What additional checks would you find most helpful? Let me know.