May 3, 2012 at 12:58 pm
In an SQL 2008, I have created an alert for a user db size. On crossing that limit, alert is mailed out. It also runs a job. In the Alerts tab, there is count which shows Number of Occurences. What does it indicate?
Even when I have set the response time to 4 hrs (in a day, 6 alerts, 6mails), I see that number keeps increasing even during the waiting interval (between one alert and the next).
Could any one please clarify?
May 3, 2012 at 4:14 pm
its simply a count of the number of times the event that fires the alert has occurred. As you have a response delay not every occurrence fires the alert
---------------------------------------------------------------------
May 3, 2012 at 9:13 pm
Thanks for the reply.
That alert has been set for, say 100 mb of data file. During the time of creation of the alert itself, the size is over 100 mb. So, the alert gets triggered regularly, sometimes once every minute. Mails sent as per the delay. So,
1. Whats the interval between 2 alerts (since size is already >100 mb)
2. Is there a way to bring down/stop such triggers and make it trigger only at times mentioned in the response delay.
3. If there is no way to bring it down, would it cause an issue? At the rate the Number of Occurences increasing, it would cross some 50K in a day. If the count is an issue, Is there an maintenance task to reset the counter?
May 4, 2012 at 6:08 am
the alert will continue to fire until something is done to reduce the amount of data, thats the expected behaviour, I don't believe that can be changed.
you can reset the count from the history tab of the alert, tick the reset count box and hit ok.
The column that holds that value is defined as an int so can go up to 2,147,483,647. Should you exceed that you would get an overflow error and I presume the alert would error out. You would then have to reset it.
---------------------------------------------------------------------
May 4, 2012 at 9:32 am
Change or disable the alert. It makes no sense to have an alert for a condition that is already exceeded.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply