Question: An application owner reported slow SQL Server database response times . Using a query through the default trace and searching on the Trace event id “Data File Auto Grow” , I identified some long running DATA FILE AUTOGROWTH activity. The duration column displayed some extended time periods. Why is it so slow?

4) Monitoring of data autogrow events , will supply information to DBAs. Use the information to grow the files in non-critical hrs. Make sure you maintain a disk space monitor – as autogrow will continue up to disk full – if MAXSIZE isn’t used

5) Speak to the storage guy . Before you speak to them gather Perfmon statistics – such as Logical Write Bytes \sec and Logical Read Bytes/sec