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

multiple inserts multiple connections -blocking Expand / Collapse
Posted Tuesday, April 29, 2014 6:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 386, Visits: 1,898
In our environment we have table which gets populated through multiple connections. Just a single insert statement from multiple connections. Similar to like insert into table A values (a,b,c). This insert command is triggered from different servers. The table has a clustered index. As the number of insert queries increase the blocking occurs and this in turn making the server to choke. We are planning to change the clustered index to non clustered index hoping that it might resolve the issue. Any suggestion ? common wait type during this insert process pagelatch_ex and pagelatch_sh.
Post #1566184
Posted Wednesday, April 30, 2014 12:04 AM


Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Evaluate the possibilities of "Snapshot Isolation" in your environment.

"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1566213
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse