Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 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

 
discard

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.