By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,626 Members | 1,657 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,626 IT Pros & Developers. It's quick & easy.

Find which session is creating temp tables in temp db

P: 1
Can anybody help me to find out which sessions are creating temp tables named like '#children_________00000XXXX' in tempdb. Which are having more than 500,00 rows and not dropped from last two days.
Dec 29 '15 #1

✓ answered by zmbd

From what I've read, if you are using SQLServer2005 - 2008R2 you might be able to pull this from the trace log. In new versions such as 2012 from extended events.

There are a few blogs out there covering this information; however, this is well beyond my area of expertise. If you will use your favorite search engine with your version of SQL Server, and "who owns that #temp table" as keywords, it should turn up a few such blogs with some explanations behind the techniques.

Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
From what I've read, if you are using SQLServer2005 - 2008R2 you might be able to pull this from the trace log. In new versions such as 2012 from extended events.

There are a few blogs out there covering this information; however, this is well beyond my area of expertise. If you will use your favorite search engine with your version of SQL Server, and "who owns that #temp table" as keywords, it should turn up a few such blogs with some explanations behind the techniques.
Dec 29 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.