1

My tempdb data file has grown significantly in size and I'd like to get an understanding of who made the change, this is a fairly recent event and there are no autogrowth events in the disk usage reports so it would suggest that the file was grown manually. My question was, is it possible to find out when a file was last manually grown and if so by what increment?

Improve this question
1
  • Fairly recent could still mean that the default trace used to track auto-growth events doesn't have the event stored. So, maybe it was auto if it's a pretty busy server. This is where auditing comes in. However, i'd ask this on dba.stackexchange.com. You're more likely to get a good answer for this question over there. Commented Jun 14, 2018 at 19:11
Related questions
0
SQLServer tempDB growing infinitely
2
Sql Server 2000 - tempdb growing very large
2
TempDB Log File Growth Using Global Temp Tables
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.