What’s Causing Files to Automatically Grow

Recently I read a blog post on What’s Causing Files to Automatically Grow and I am wondering if there is a way to actually capture the forced (non-automatic, on-demand) growth of files.

I did some tests (correct me if I am wrong!) and I noticed that the following Profiler events

  • Event 92 = Data file auto growth event
  • Event 93 = Log file auto growth event

are not capturing the user-intended growth of files.

This is important to me because on several occasions I have seen scheduled SQL Server Agent jobs which grow or shrink the files regularly. I have also seen rookie DBAs to grow and shrink database files as well.

Any comments? Ideas?


Comments are closed.