[sp_HealthCheck] – Get SQL Server Health Details

Spread the love

Hi Friends,

Ever wanted to check the heartbeat of SQL Server. It is a 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 command.

We can get all this information by using my stored procedure [sp_HealthCheck]. Below is the latest code for the procedure:-

Following is a sample result for some of its output.

Friends! Please feel free to correct me by comments. If you like the article, do Like and share. Happy Coding πŸ™‚

Credit:- The inspiration and some piece of the code of this procedure belong 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.