February 19, 2004 at 12:43 pm
Can anyone tell me what the following error message means?
Error string: SQL Server has run out of LOCKS. Rerun your statement when there are fewer active users, or ask the system administrator to reconfigure ... Process Exit Code 1. The step failed.
February 19, 2004 at 1:24 pm
What did you try to do when you received this error? What is your locks Option setting? You can get it from sp_configure.
February 19, 2004 at 1:35 pm
This message is part of the job history (scheduled job failed).
This is what I get from sp_configure...
name min max config_value run_value
locks 5000 2147483647 0 0
February 19, 2004 at 1:52 pm
How much memory the server has? Do any other applications run in same server? How is memory be configuered in SQL Server? It looks like you have some memory shortage issue. Run performance monitor to collect memory counters to see how much memory left and how heavy the paging is when this error occurs if you can reproduce the problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply