Post reply

Setting up Size alerts

  • July 13, 2004 at 3:15 am

    #88163

    Hi All:

    I want to setup alert on our production SQL Servers to alert dba's on database size. i.e. we want to alert dba's when any database is 85% full.. any idea's suggestions

  • July 13, 2004 at 4:03 am

    #514359

    there are a couple of ways of doing it

    but i prefer

    use mydatabase

    go

    select count (*) from sysfiles where maxsize -1 and (size/maxsize)>0.85

    this will tell you how many files are over the 85% threshold (assuming they have a max size set)

    MVDBA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply