[dba-SQLServer] Cannot obtain a lock

Did you solve this problem John?


On Tue, 7 Sep 2004 12:11:53 +1000, Michael Maddison
<michael at ddisolutions.com.au> wrote:
> Not my area of expertise but...
> 
> try in QA
> EXEC sp_lock
> and
> EXEC sp_who
> 
> and KILL
> any blocking processes.  Look up BOL for details on each statement.
> 
> HTH
> 
> Michael M
> 
> 
> 
> 
> 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
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



-- 
-Francisco