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.
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.
Have you been taking advantage of Elements Health Checks? What additional checks would you find most helpful? Let me know.