SQL Server Performance Forum – Threads Archive

Help Creating Low Hard Drive Space SQL Alert

how can i create an alert in sql, that would notify me, i would be running out of space on my database drives very soon???….
Thanks

By default when a partition has less than 10% free disk space an event ID 2013 is created with the following text
"The disk is at or near capacity. You may need to delete some files". To view these events use Event Viewer, however it is possible to change the percentage that the alert is created. Refer to thishttp://www.databasejournal.com/scripts/article.php/1470811 link for the script in alerting. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

You can also create a custom system based on the extended stored procedure xp_fixeddrives in the master database. You need to store a list of your drive capacities somewhere as xp_fixeddrives only reports free space. You can consolidate this all on one server then run a stored procedure to check all the freespace info once a day and raise custom errors/alerts. I do this but I produce it all in a web page then use a 3rd party piece of software (‘Servers Alive’) to read the web page automatically and then email me if server’s free space has fallen below set thresholds. But you could also just check the page manually. Tom Pullen
DBA, Oxfam GB

thanks guys

]]>