Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can I set alerts for an autogrow event in SQL Server (2005 or 2008 R2)?

I've searched around and haven't found the 'error number' for autogrowth, if there is one.

In case this isn't possible, how else do you suggest setting up alerts for autogrow?

I've thought about configuring SQL Server notifications with Service Broker as an alternative, but I'm open to suggestions.

share|improve this question
up vote 2 down vote accepted

I think Event Notifications for DATA_FILE_AUTO_GROW and LOG_FILE_AUTO_GROW are the appropriate way. Since the autogrowth events are not errors they cannot be detected by the SQL Agent eventing infrastructure so EN is pretty much the only reasonable alternative.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.