Error: When 701 of memory is insufficient, use DAC to connect.

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.