MSSQLSERVER_1204 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


HI, I have a problem with SQL Server 2005 Cluster configuration. I change the the resources from Node A to Node B and every think looks fine. When I tried to run a query I got this message: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions. Can any body please help me with this. I saw somethink with the SQL Server Configuration Seetings, the number of locks is 5000. I read in the msdn but I coudn’t figure out how to fix the problem Thanks in advance
I am locking this… it is duplicate… MohammedU.