multiple inserts multiple connections -blocking

  • 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.

  • 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."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply