get queries affecting tempdb?

• anuragingle

  SSChasing Mays

  Points: 652

  More actions

  June 2, 2011 at 2:02 am

  #237371

  is there anyway to get a list of all the queries currently running on sql server which are affecting tempdb and the users/login ids for those queries?

  Only those queries which can cause tempdb size to grow should be listed.

  is this possible?

  Thanks

• mazzz

  SSCertifiable

  Points: 6139

  More actions

  June 2, 2011 at 3:37 am

  #1332977

  Take a look at this blog post as a starting point:

  http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html

  From the query there you could filter out records where the objects (internal/user) allocated are significantly larger than the objects deallocated over time

  ------------------------------------------------------------------------
  Bite-sized fiction (with added teeth) [/url]

• M&M

  SSC-Insane

  Points: 21700

  More actions

  June 2, 2011 at 3:54 am

  #1332981

  Details are there in this whitepaper. Check link below.

  http://technet.microsoft.com/en-us/library/cc966545.aspx

  M&M