I've been doing a little work on trying to improve performance of our HBA's in our SQL servers. We've done some extensive testing on Queue Depth settings as that's one of the settings to change to ...

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 ...