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

Enterprise Manager SQL2000 SP4 - table lock Expand / Collapse
Author
Message
Posted Thursday, April 9, 2009 2:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 9:05 AM
Points: 1, Visits: 6
Hi all,

we have a old application in our company, which is using SQL Server 2000 SP4.
Sometimes if a developer makes a SELECT on a table, this SELECT locks the table (but the SELECT was completed and only the result is shown) and everybody, who using this table in the app gets an Timeout.

What can I do to solve this problem ?

Thanks for all response

cya
Jens
Post #693795
Posted Thursday, April 9, 2009 2:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 8, 2014 3:25 AM
Points: 2,283, Visits: 781
if you can risk gost data in your select statement then you could change the code to use NOLOCK

Select * from table WITH (NOLOCK)

there are certain risks involved (possible missing rows, or duplicate rows) but if you evaluate your environment and any actions you are going to drive from this data that you select, then you might consider it a worthwhile fix

evaluate and consider carefully before implementing this though.



MVDBA
Post #693804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse