I had a SQL Server fee disk space monitor job in my environment which throws an alert when the free space on any drive drops below a threshold free space. But it did not have the information to help us directly attack the server and the right drive and which folder and file exactly has grown. So I have decided to have the information handy. When I can receive the alert then why not in detail? So here is the stored procedure which sends an alert when any drive size drops below a set threshold and also includes an attachment of all the folders and files inside each folder and its size in Bytes in the drive where we have the space crunch. Also in the mail it provides the information of which drive is running low on space.

If you have any issues with the code please feel free to get back to me.

Happy Monitoring.



Manohar Punna

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook