Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:01 AM
Points: 1,299, Visits: 3,003
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 11:45 PM
Points: 24, Visits: 152
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