Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

which one is right? Expand / Collapse
Posted Thursday, November 8, 2012 7:47 AM


Group: General Forum Members
Last Login: Friday, November 18, 2016 9:50 AM
Points: 1,525, Visits: 3,573
GilaMonster (11/7/2012)
sqldba_newbie (11/7/2012)
The locks are heldup for longer durations, how do i handle that?

Longer duration than what?

Application is running slow and i do see the calls made by webserver are blocked.
Post #1382503
Posted Sunday, November 11, 2012 4:01 PM


Group: General Forum Members
Last Login: Thursday, October 13, 2016 4:18 PM
Points: 24, Visits: 155
The right way to fix this is figure out why you have long running transactions that are blocking reads. In the SQL Server world, we like to see short, quick transactions. If you are having this issue without a high level of concurrency, you should look into your code to see why your transactions are blocking so long. If that doesn't solve it, I agree that read committed snapshot is the right approach. DO NOT use READ UNCOMMITTED.

Post #1383478
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse