sp_health_check quickly outlines key facts about the status and specs of a Microsoft SQL Server which gives a starting point to address current and potential issues. Despite the fact that there are multiple queries executed by the stored procedure, the data in question is mainly retrieved from memory, so it is safe to be run in production. It contains a waitfor delay, which […]Read more "Overview"
I created sp_health_check because I constantly needed to get a basic status and specs of Microsoft SQL Servers that I was not familiar with. At that time, I was working as a DBA for a major company that had a couple thousand instances in which I would constantly assist with incidents. That required me to […]Read more "Purpose"