SQL Server Performance

alert if database it larger then xxxGB

Discussion in 'SQL Server 2005 General DBA Questions' started by avipenina, Apr 17, 2008.

  1. avipenina New Member

    Hi,
    i want to be alerted when any of my databases is more the xxxGB.
    i know one method to do that and it is with the alerts in the SQL agent Performance condition ,but with this alert when i choose to monitor on all databases the results is that i can't see the database name in the alert when i get it.
    do you know a better way to achieve that ?
    avipenina, Apr 17, 2008
    #2

  2. Luis Martin Moderator

    Did you get ID database?
    Luis Martin, Apr 17, 2008
    #3

  3. avipenina New Member

    no.i don't receive any identification on what is the alert,only by the Alert name that i give when i create the alert.
    avipenina, Apr 17, 2008
    #4

  4. ghemant Moderator

    Hi,
    you can configure alert for specific database if it grows beyond certain size, go to SSMS->SQL Server Agent->Alert->New Alert
    hth
    ghemant, Apr 18, 2008
    #5

  5. avipenina New Member

    i know that.
    but i want to monitor all databases.
    avipenina, Apr 18, 2008
    #6

  6. ghemant Moderator

    You can configure an alert for the All Databases as well, or similarly you can create a job and schedule it to run daily
    ghemant, Apr 21, 2008
    #7

  7. avipenina New Member

    i don't want to create for every database an alert.
    i want to create one script that will run twice a day and will check every database size.if the size i greater then 40GB then send email alert.
    i start to write a script with cursor but then i was stuck with the code.
    avipenina, Apr 21, 2008
    #8

  8. satya Moderator

    satya, Apr 22, 2008
    #9

Share This Page