which one is right?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » Administering » which one is right?

Add to briefcase

12 posts, Page 2 of 2

««1 2

which one is right?

Expand / Collapse

Author

Message

Posted Thursday, November 08, 2012 7:47 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 1,178, Visits: 2,701

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

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 10:53 AM
Points: 24, Visits: 139

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 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse