Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    97

    Unanswered: Data File Size Alert

    I've set up an alert to email me whenever the database is over a certain size. The amount is calculated by taking 80% of the total data file size. The problem I'm having is that it keeps generating a false positive alert because MS SQL seems to treat the currently used value as the total allocated space for the database data file. For example, the data file is 100MB, it's currently using 60MB, and if I enter 80MB in the alert, it generates an email alert claiming the current size is 100MB. Could it be because the data file size is set to 100MB (since autogrowth is disabled)?

    TIA

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    What is the purpose of this alert? How much disk space is available? Is there some concern that there will not be enough disk space and capacity will be reached? Why is autogrowth disable? 100mb seems small.

  3. #3
    Join Date
    Mar 2003
    Posts
    97
    I ask the questions. You answer.

  4. #4
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by naceBal View Post
    I ask the questions. You answer.
    I'm not your bitch.

  5. #5
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    I ask the questions. You answer.
    Two thoughts quickly came to mind:
    1. Who the hell do you think you are?
    2. Once you start paying for the service. Maybe.

    When people ask for additional information, you need to simply provide it - rather than being snotty.

    Apologies to the sensitive. . .

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •