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

• bharatchand

  Grasshopper

  Points: 14

  More actions

  July 5, 2013 at 8:58 am

  #104203

  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

• balasaukri

  Default port

  Points: 1443

  More actions

  July 5, 2013 at 9:30 am

  #1630126

  Refer the other thread...

  http://www.sqlservercentral.com/Forums/Topic1469888-146-1.aspx

  Might be useful to you to find out.

• bharatchand

  Grasshopper

  Points: 14

  More actions

  July 5, 2013 at 10:33 am

  #1630140

  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

• balasaukri

  Default port

  Points: 1443

  More actions

  July 5, 2013 at 9:18 pm

  #1630209

  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/