TempDB unexpected growth
I think it would be a good idea to have information about what caused random sudden growth in tempdb. I know we can see the DB size chart but theres no way to know what caused it.
Information that would be nice to be captured:
Table name
What query created table
What user created table
Jesus Zambrano
shared this idea
TempDB metrics are now available on the server overview page from version 11.0.
-
Hello,
Thank you for your suggestion, SQL Monitor 10.2.7 now offers some insight into how space is utilised within tempdb. We hope these metrics are useful to you and your feedback is very welcomed as we progress with this feature.
Thank you
-
Jesus Zambrano
commented
To add to this it would be nice to see what transactions caused the transaction log to grow significantly. We had another issue where over the weekend a transaction ran that filled up the log but by the time we got to troubleshoot the issue was gone.