SQL Server 2008 database size alerts


  • Guys I'm going to be putting in a database mirroring solution for our Sharepoint 2007 farm. I will not be using SQL servers auto grow features instead I will manually set the size of all log files and database files. However since I'm not using auto grow I would like to be able to configure some type of alerting. For example, if I have a 20 gig file and I it only has 2 gigs of free space left I would like to receive an email alerting me that I need to check on the data file. So can anyone here suggest a method for accomplishing this?
    Tuesday, January 05, 2010 3:45 PM


  • Hi there,

    There is way of doing this through SQL server in-built feature of AGENT ALERTS.

    To configure this for your case , do the following.

    Open sql server agent
    Right click alerts and select new alerts
    provide a name for this alert
    Set the type as SQL server performance condition alert.
    Choose SQL server: DATABASEs from OBJECT drop down box.
    Choose datafile size(kb) from counter
    Choose the exact databasename from instance drop down box.
    Then enter value (in KB) as your thershold limit .

    You may set this alert to be sent to you via operator.

    Thanks, Leks
    Tuesday, January 05, 2010 10:23 PM