The SQL Server cannot obtain a LOCK resource at this time
Posted on 2004-11-15
I have a sieries of jobs in SQL Agent which are berforming BULK INSERTS. Bulk Insert uses WITH(TABLOCK) and batch sets. If i run more that 4 jobs simultaniously i get:
The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.
SET LOCK_TIMEOUT -1 is being used to allow an infinate lock timeout period.
Memory config is @ default settings (no tweaks) and there is 4Gb on sever in total (allowing SQL to have 2g)
Any ideas ?