Skip to main content

Need Help Using Spok Knowledge?

Internet Explorer is not supported. Please reload in Chrome, Edge, Firefox, or Safari.

SQL Insufficient Memory Error


Customers running SQL 2012 - SP1 may get insufficient memory errors.   

This is a known memory leak issue with Service Pack 1.   This will continue to occur unless the SQL service pack is updated - recommend Service Pack 3.

Temporary Resolution:  Restart server


To check the SQL Service Pack:

    Open SQL Server Management Studio
  Create a new query
        Query:    SELECT @@VERSION 

     Execute the Query

Note: you may need to restart the server to clear the memory error before you can log into SQL Server Management Studio to check the version.

Some symptoms may include:

         - Cannot access EADM, receive "No process is on the other end of the pipe" error. 

- Cannot log into SQL Server Management studio. 

- Cannot restart SQL Services

- Receiving "named pipe" error