Diagnosing: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time

Have you ever had the joy of receiving this error 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 […]

Read More