SQL table disk size alert

From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 08/29/02


From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr>
Date: Thu, 29 Aug 2002 09:55:48 +0300


Hi,
I have an SQL table which gets larger and larger every day. I want to set a
property that checks the size of the table and when it reaches a threshold
an alert is triggered, so that my table is not over the quota. Is there such
a property in SQL or another tool?
Regards,
Tolga



Relevant Pages

  • Re: Large Amount of Memory Message
    ... But wasn't really sure how to match each instance of SQL with a specific ... physical RAM - in other words, if it's using the page file. ... Memory Properties) means so I don't want to necessarily change the alert: ...
    (microsoft.public.windows.server.sbs)
  • Re: Large Amount of Memory Message
    ... For PID# 2004 it still doesn't clarify which application is running with SQL. ... physical RAM - in other words, if it's using the page file. ... Memory Properties) means so I don't want to necessarily change the ... I went in and set the alert threshold to 110 or 120% of the 30-day ...
    (microsoft.public.windows.server.sbs)
  • Re: Large Amount of Memory Message
    ... But wasn't really sure how to match each instance of SQL with a ... It's alerting you if the server is using more memory than the amount ... physical RAM - in other words, if it's using the page file. ... I went in and set the alert threshold to 110 or 120% of the 30-day ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Replikation und Alerts
    ... Am besten per Mail und per "net send". ... Der Alert ... Liegt das an der Trail Version vom SQL 2005 oder ist das ... Hat er einen eigenen SMTP Server integriert oder muss ich ...
    (microsoft.public.de.sqlserver)
  • Re: SQL2000 Alert question - Tricky!
    ... > the PROGRAM used for SQL server connectivity. ... > The login failed alert has the message_id mapped to the ... What we'd like to get is the hostname and the program name ... > querying sysprocesses, provided the login succeeds. ...
    (microsoft.public.sqlserver.security)