SQL Server Performance Forum – Threads Archive

Reg Concurrent execution of Procedure..

How can i execute a procedure concurrently without deadlocks.
I have used all table hints and indexes appropriately as per my knowledge..
And when i execute a procedure concurrently it results in Blocks..(meaning it runs
indefinitely and when i look for sp_who my transaction is getting blocked..WHy it is getting blocked..Also if i run it for 4 users it is getting sequentially esxecuted (meaning one process gets over after the other..) i need to run them in parallel..
Is there any concept of horizontally partitioning the data so that i can avoid such issues..

Are you able to post your stored procedure? How large and complex is it? There should be a way to achieve what you want… although if you have an update/delete/insert statement near the top of the procedure then you may find other procedures get blocked until the first one commits. Choices then are to: - have commits within the procedure (and thus lose the ability to roll the whole procedure back) - attempt to spread the update/delete/insert using a clustered index on columns which force rows to be in different parts of the table Hard to give clear guidance without knowing in more detail what the code is doing <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> Cheers Twan

]]>