I am hoping you can help me out here.
SQL Server 2014 SP2 CU8
Windows Server 2012
3 instances on one server (but hardly used)
We have a daily restore that happens - taking .bak files from our production server and restoring them to another Non Production server. We use PowerShell to copy the bak files over then we have an SQL Agent job that drops all the current databases and restores the bak files one at atime. The process has been working for overone year now.
Suddenly the restore is failing with the following error message
RESTORE FILELIST is terminatingabnormally. [SQLSTATE 42000] (Error 3013) The instance of the SQL Server Database Engine cannot obtain a LOCKresource at this time. Rerun yourstatement when there are fewer active users. Ask the database administrator tocheck the lock and memory configuration for this instance, or to check forlong-running transactions. [SQLSTATE HY000] (Error 1204)
I am also getting the following error in the SQL Server Error Log
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 7216 seconds. Working set (KB): 542564, committed (KB): 2194080, memory utilization: 24%.
We checked the memory configuration on the instance and it is set to the default.
Today we rebooted the server – it’sa VM
The restore happens at 2AM, so there are litteraly are no users connecting to the machine,
We are constantly dealing with SAN latency issues and I wonder if this could be the cause.
Please any help isappreciated.