The Data File Autogrow alert indicates that a data file autogrow occurred on the specified database. For this alert to display, enable monitoring of non-query activities with capturing of autogrow events. Note that you can avoid unnecessarily long reads and poor response time from SQL Server by minimizing the number of autogrow events occurring in your environment.

This alert is raised based on the diagnostic data collection interval specified in Server Properties. For more information, see Set general server options.

To learn more about how autogrow works and related best-practices, see , "Considerations for the 'autogrow' and 'autoshrink' settings in SQL Server."

Create an alert response bundle with the Data File Autogrow alert and related alerts.  For additional information, see Create alert response bundles.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal