May 11, 2013 at 1:34 pm
Specifically, a tempdb usage script that returns some usage/space stats, but also lists the sql server text/query associated w/tempdb activity.
I saw some DMVs that can accomplish this, but haven't been able to find them.
If you can get per file, possibly, that would be good too.
Thanks in advance!
May 11, 2013 at 4:46 pm
How about right click on tempdb / Reports / Standard Reports?
May 11, 2013 at 4:48 pm
thx - kinda looking for some t-sql code/script to do this. Any ideas? 🙂
May 11, 2013 at 5:06 pm
A quick google search returned this see if it helps at all
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply