Concurrency and deadlocks...what should i do RRS feed

  • Question

  • Hello forums,

    Ive been reading a  bit on concurrency and deadlocks while i doubt i understand it 100% i thhink i got the general basics. But according to my reading material (

    Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer) [Paperback])

    The Default isolation leel is READCOMMITED and i can set the lock time out to 5 seconds so if a deadlock occurs one transaction is killed...etc etc

    but the thing is thats all i can see that needs to be done but according to my reading, dead locks and concurrency problems are one of the worst thing that could happen to a database. But i dont know what else to do cause according to my untrained eye everything has already been accounted for. So I was just looking for any general tips or stuff to look out for. Thanks

    • Changed type Naomi N Thursday, April 19, 2012 1:22 PM Question rather than discussion
    Thursday, April 19, 2012 12:54 PM


All replies