SQL Server 7: Error Msg - Error: 1222, Severity: 16, State: 50 Lock Request Timeout period exceeded 
Author Message
 SQL Server 7: Error Msg - Error: 1222, Severity: 16, State: 50 Lock Request Timeout period exceeded
Hi,

I am regulary getting the above message, localised within a particular
database on our server.

I realise that this is a locking problem but how can I get more
information about this and where it is occuring.

I have been advised to use a trace, can anybody advise me what trace
flag to use to be able to localise where the errors are occuring.

Any help would be welcome

Thank you
-BKaur



Mon, 14 Feb 2005 17:11:19 GMT
 SQL Server 7: Error Msg - Error: 1222, Severity: 16, State: 50 Lock Request Timeout period exceeded

Balwinder,

Frankly this is more a guess than anything else, but I suspect that your
application might have the LOCK_TIMEOUT specification set somewhere in it.

Additional information on the setting can be found in the section "SET
LOCK_TIMEOUT" in the SQL Server 7.0 Books Online.

Re: tracing ... you might consider reading up on the SQL Server Profiler
which can let you track long running queries. Again, documentation on
Profiler can be found in the SQL Server 7.0 Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> Hi,

> I am regulary getting the above message, localised within a particular
> database on our server.

> I realise that this is a locking problem but how can I get more
> information about this and where it is occuring.

> I have been advised to use a trace, can anybody advise me what trace
> flag to use to be able to localise where the errors are occuring.

> Any help would be welcome

> Thank you
> -BKaur



Mon, 14 Feb 2005 23:46:47 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error 1222 : Lock request time out period exceeded in Enterprise Manager

2. Error 1222 = Lock request time out period exceeded

3. HELP - SQL Server 7.0 Error - Msg 542, Level 16, State 1

4. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

5. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

6. Error 1222: lock request timeout period exceeded

7. Server: Msg 107, Level 16, State 3 Error

8. Select error:Server: Msg 8120, Level 16, State 1, Line 1

9. Error Message: Server: Msg 7392, Level 16, State 2

10. Error: Server: MSG 7392, Level 16, State 2

11. Unstable sql server - locking/blocking/1222 errors help pls

12. Help: SQL Error: Msg 7134, Level 16, State 2


 
Powered by phpBB® Forum Software