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

Temp DB- I would like to know how to identify the exact query or stored proc which is actually filling up the transactional log of TEMPDB database Expand / Collapse
Author
Message
Posted Friday, July 5, 2013 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 5, 2013 12:01 PM
Points: 2, Visits: 3
I would like to know how to identify the exact query or stored proc which is actually filling up the transactional log of TEMPDB database
Post #1470782
Posted Friday, July 5, 2013 9:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:06 AM
Points: 42, Visits: 248
Refer the other thread...
http://www.sqlservercentral.com/Forums/Topic1469888-146-1.aspx
Might be useful to you to find out.
Post #1470796
Posted Friday, July 5, 2013 10:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 5, 2013 12:01 PM
Points: 2, Visits: 3
Hi,

Thanks very useful.

Quick question that query will shows old what's been used in Tempdb or the running one.
if i need to know the culprits which filled the tempdb.

Regards
Post #1470813
Posted Friday, July 5, 2013 9:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:06 AM
Points: 42, Visits: 248
Hi - Use the default trace! Pl refer the below link, will tell you more in detail

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/
Post #1470895
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse