SQL Server Performance Forum – Threads Archive
SQL Server Agent Alert-DB File Size across drives?
Hey folks,<br /><br />I’m currently trying to create a SQL Server Agent Alert that will send us an email when any of the database disk(s) are at >= 75% of disk capacity. The problem with the built-in performance condition event alerts is that using the "_Total" instance for SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />atabases, Data File(s) Size (KB) option won’t do – our data files, tempdb, transaction log, backup files are on different drives. Does anyone have any suggestions?<br /><br />Thanks!<br /><br />-GiorgioI can only think of writing a SQL job which will check the size and free space of each drive, and fires off an errormessage of a specific severity or number, which then triggers an alert Cheers
Twan
Can take help from this linkhttp://vyaskn.tripod.com/track_sql_database_file_growth.htm&e=7415 to enable the monitoring alerts.# http://www.sswug.org/see/13947&e=7415 for SQL defined alerts. 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.
]]>