Reputation
Top tag
Next privilege 100 Rep.
Edit community wikis
Badges
9
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Feb
23
awarded  Popular Question
Jul
2
awarded  Curious
Jun
2
awarded  Popular Question
Aug
27
awarded  Supporter
Aug
27
accepted SQL Analysis Services - SSAS
Aug
27
accepted Executing the query “UPDATE STATISTICS [dbo].[Contact] WITH FULLSCAN …” failed
Aug
27
accepted Binding errors with dependent stored procedures
Dec
5
awarded  Teacher
Dec
5
answered Binding errors with dependent stored procedures
Dec
5
accepted Database Indexing - Maintenance Jobs
Dec
5
answered Database Indexing - Maintenance Jobs
Dec
5
accepted SQL 2008 RTM Temp Tables
Dec
5
comment SQL 2008 RTM Temp Tables
Thanks I will continue to monitor the number of tables, the app seems to have about 300-400 at any given time in our Live Environment. Will also look at dumping the temp table info as indicated below.
Dec
5
awarded  Scholar
Dec
5
awarded  Editor
Dec
5
revised Binding errors with dependent stored procedures
added 248 characters in body
Dec
5
awarded  Cleanup
Dec
5
revised SQL 2008 RTM Temp Tables
rolled back to a previous revision
Dec
5
asked Binding errors with dependent stored procedures
Nov
30
comment SQL 2008 RTM Temp Tables
I dont think it is caused by our monitoring solution because that simply selects from sys.dm_os_performance_counters. At about 1 AM this morning all the temp tables were cleared and at about 6AM when the users started testing again the count started increasing.