Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Looking for a TempDB usage script.... Expand / Collapse
Author
Message
Posted Saturday, May 11, 2013 1:34 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 8:10 AM
Points: 64, Visits: 161
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!
Post #1451853
Posted Saturday, May 11, 2013 4:46 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 288, Visits: 1,822
How about right click on tempdb / Reports / Standard Reports?
Post #1451868
Posted Saturday, May 11, 2013 4:48 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 8:10 AM
Points: 64, Visits: 161
thx - kinda looking for some t-sql code/script to do this. Any ideas?
Post #1451869
Posted Saturday, May 11, 2013 5:06 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 288, Visits: 1,822
A quick google search returned this see if it helps at all

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspx

Post #1451870
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse