Ever wanted to check heartbeat of SQL Server. It is very common activity for a SQL Server user to check CPU, SQL Memory Utilization, Available Memory with OS, Currently executing queries, Space Utilization of Volumes/Drives, Usage of Data/Log Files, Blocking Tree and any session running ROLLBACK/CHECKDB/BACKUP commnd.
We can get all this information by using my stored procedure [sp_HealthCheck]. This procedure is part of my project sp_HealthCheck in GitHub repository SQLDBA-SSMS-Solution. You can find latest code of this procedure at below path:-
Friends! Please feel free to correct me by comments. If you like the article, do Like & Share. Happy Coding 🙂
Credit:- The inspiration and some piece of the code of this procedure belongs to my friends in United Health Group named Chandu & Anil.