Detecting and reporting when a SQL Server database data or log file experienced a growth operation can be very useful for many reasons, such as:
- Analyzing and predicting disk space utilization on the server
- Detecting optimum values to setup for database growth
- Detecting any long running transactions that causes growth in log or data files.
In this post I present a simple method for querying information regarding database growth activity within a SQL Server instance, as well as setting up a simple email alert that gets triggered based on a configured growth threshold.