Posted: Mon Jun 20, 2011 10:11 pm Post subject: Instance of SQLServer Database Engine cannot obtain a lock
We are using BODS 126.96.36.199 and SQL Server 2008. We have devloped around 30 Jobs. When we are running those jobs in parallel, we are facing the below issue.
[Microsoft][SQL Server Native Client 10.0][SQL Server]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.