Previous testsSQL Server 2014Memory Database, if the database size exceeds the configured maximum memory,SQL ServerAppearsError: 701Error.
Error message:
Error: 701, severity: 17, state: 123.
There is insufficient system memory in resource pool 'internal' to runthis query.
At that time, I deleted the database and restarted it. In fact, I used it when the memory is insufficient.DACIt can still be connected.
The following is my test:
Default Connection Failed:
UseDACConnection successful(You can also useSqlcmd DAC ):
Because I still had memory resources on the server at the time, I can directly modify the maximum memory:
Sp_configure 'show advanced options', 1;
Go
Reconfigure;
Go
Sp_configure 'max Server Memory ', 4096;
Go
Reconfigure;
Go
DACYou can check the status of the system and find some problems.SessionCan be processed, so you do not need to restartSQL Server, and timely detection of problems.