Find Data File Auto Growth event in SQLServer Database

by Snehashish Ghosh

Find Data File Auto Growth event in SQLServer Database

Step 1: Find the default trace file name

 Step 2: Find the Event Class related to Data File Auto Grow,Log File Auto Grow.

                              The Event class for Data File Auto Grow is 92

                              The Event class for Log File Auto Grow     is 93

Step 3: check if the Event Class have been reported in the default trace file

Step 4: To check all Data File Auto Grow,Log File Auto Grow events perform Step 3 for every trace file available in the server.

 What’s next

Based on the results of the query the datafile and log file need to be properly sized so that the events are not trigerred.

It has been observed that if the datafile and log file size is greater than 100 GB, then the auto growth event is very costly which might lead to system slowness.

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

*