Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help on blocking in tempdb Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 9:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:57 AM
Points: 332, Visits: 851
On one of our 2008 R2 SP2 sql server we are experiencing blocking in tempdb. The blocked requests are Intellisense and Data Collection queries. We have found some stored procedures that create but do not drop temp tables, their connection starts when application begins and ends when application is terminated. We are having these stored procedures changed. Just wondering if anyone else has experienced this.

Server has 16 Processors, 65 gb and tempdb has 4 data files of equal size.
Post #1469591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse