[dba-SQLServer] Cannot obtain a lock

John W. Colby jwcolby at colbyconsulting.com
Mon Sep 6 13:30:45 CDT 2004


Well, if it ain't one thing its another.

NOW... The server has stopped processing and all the workstations are
stopped as well.  When I try to look at the server properties I get:

"The SQL Server cannot obtain a lock resource at this time.  Rerun your
statement when there are fewer users or ask the system administrator to
check the SQL Server lock and memory configuration".

Unfortunately I can't check the server lock and memory configuration because
I get an error... "can't obtain a lock resource..."

I am trying to cancel one of the 4 machines import to see if that frees up
enough resources to go look at the problem, but I have to wonder if the
rollback can be done if it can't "get a lock resource".

Is there anything that can be done here?

John W. Colby
www.ColbyConsulting.com 






More information about the dba-SQLServer mailing list