Is there a way to tell when a data file has auto-grown?

• tosscrosby

  Hall of Fame

  Points: 3140

  More actions

  March 23, 2006 at 2:33 pm

  #116658

  Is there a way to tel precisely when a data file has auto-grown? I know it was over the last 2 weeks but I'd like to be more exact to see it I can determine if this did indeed cause Error: 17883 as MicroSoft says AUTOGROW can be one of the symptoms to raise this error.

  
  Terry

• Martin Mojzisek

  SSCrazy

  Points: 2187

  More actions

  March 24, 2006 at 1:56 am

  #628525

  You can set up a profiler trace, under Database, there are Data File Autogrow and Log File Autogrow events.

  Hope this helps.

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  March 24, 2006 at 9:37 am

  #628666

  We've been getting the 17883 (which have many causes) as well.  I will share all the info I know. 

  http://support.microsoft.com/kb/892940

  http://support.microsoft.com/kb/890730

  http://support.microsoft.com/kb/810885

  http://support.microsoft.com/kb/909380/en-us?spid=2852

  http://support.microsoft.com/kb/867878

  http://support.microsoft.com/kb/909089/en-us?spid=2852

   

  So... in other words.... (rolling dice)    CRAPS!

  
  
  A.J.
  DBA with an attitude

• Greg Milner

  SSCrazy

  Points: 2425

  More actions

  March 24, 2006 at 4:03 pm

  #628755

  I found this to be very helpful. It send you an Alert when any file (log or data file) grows on your SQL Server.

  http://www.databasejournal.com/scripts/article.php/1493181

  G. Milner