the SQL server database engine cannot obtain a lock ressource at this time
hello
I have a problem with the configuration of SQL Server
I have SQL Server 2019 with the last cumulative update
i fixed the max server memory with 40000 Mo =40 Go
and maxdop to 0
i have enough disk space
the problem is when i execute this query :
(insert into table A select * from table B) this probleme happen
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.
but when i execute the same wuery like this ( select * into table A from table B ) the query work fine with no problem
Can anyone help me
thanx a lot
hello I have a problem with the configuration of SQL Server I have SQL Server 2019 with the last cumulative update i fixed the max server memory with 40000 Mo =40 Goand maxdop to 0 i have enough disk space the problem is when i execute this query : (insert into table A select * from table B) this probleme happen 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.but when i execute the same wuery like this ( select * into table A from table B ) the query work fine with no problem Can anyone help me thanx a lot Read More