[sp_HealthCheck] – Get SQL Server Health Details

Spread the love

Hi Friends,

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:-

SQLDBA-SSMS-Solution/sp_HealthCheck/sp_HealthCheck.sql

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.

6 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.