SQL Update failed..Timeout

[AmeriSource]

I am running SQL server on a PC. There are about 20 simultaneous users. I often get timeout when someone is trying to update a record. My server has 512 mb or ram. I don't think its a performance problem with the server but i could be wrong. Does anyone have any suggestions??

 

[JayKusch]

what are/is the size of the table(s) you are trying to update to?

 

[AmeriSource]

The table has about 150 000 records

 

[JayKusch]

are the other users in an app or are they directly in sql server using Query Analyzer? what i am getting at is that they may be locking records with common Select statements. they need to be in a Read-Only mode if they are just querying the DB and associated tables. you may want to run Enterprise Manager as a user tries to update a record and verify if there are any locks that are occuring from others.

 

[tlbroadbent]

The most likely cause of the timeout is locking. Check the following page for some links to articles about avoiding locking problems.

http://tlbroadbent.home.attbi.com/sqlarticles.htm

It hard to determine the exact cause of the timeouts from the scanty info provided. Which version of SQL Server are you using? Are you using a server or desktop version? What is the front-end client? How are you connecting - ODBC, ADO, or other? Does the table have indexes? Does it have a clustered index? Are the users adding records, updating existing records or both? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AmeriSource]

The users are using an Access 97 front end. We were are connecting through ODBC. Some users have read only access and some have change access. The users who are updating records get the timeout error

 

[AmeriSource]

The users are using an Access 97 front end. We were are connecting through ODBC. Some users have read only access and some have change access. The users who are updating records get the timeout error

 

[AmeriSource]

We are using SQL server 7. The users are updating existing records and adding new records. We have 3 index on our table.The table has about 100 fields