I v got a website using sql server 2005 when my ws reach 1000 users at the same time I start getting deadlocks... I have a vb forum installed on the same server when I try using it It's working very well.. How Can I resolve this issue ? is it from the application ? Please help. thanks...
Hi okpara36, Deadlocks are caused when two database transactions are waiting on the same resource. Neither can complete, SQL Server detects a deadlock and rolls back one of the transactions so the other can complete. You need to identify which database transactions are causing the deadlocks. You might be able to resolve them by changing the indexing strategy to speed up the transaction or by changing the application to test for deadlocks and re-submit the transaction. There is a good article at the MS Knowledge base at: http://support.microsoft.com/kb/832524 HTH
make sure your database structure was optimized make sure you are using appropriate index and make sure your server box hardware on good condition