Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-06 : 15:50:10
|
Kaushik Majumder writes "We are a Dot.com Company
We are frequently getting an error message as...
"Server Message 1204 Level 19 State 1
SQL Server has run out of Locks. Rerun Your statement when
there are fewer active users or ask the system administrator"
We executed the following query..as
"exec sp_configure 'locks','0'
Reconfigure with override"
But the problem persists
On scrutiny we found the following :
>The RAM of our database server is 512 MB
>SQL Server.exe alone is consuming approx 412 MB
(This is happening even when server is restarted,...after
which,for a first few days the things are running ok.But
after that the same problem arises)
> Remaining Memory is hovering around 6-10 MB
Please advise us" |
|
|
|
|
|
Memory consumption by SQL Server .exe