June 2, 2011 at 2:02 am
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
June 2, 2011 at 3:37 am
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
June 2, 2011 at 3:54 am
Details are there in this whitepaper. Check link below.
http://technet.microsoft.com/en-us/library/cc966545.aspx
M&M
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply