Skip to main content
Click here if you are having trouble viewing this site
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Resources
Spok

SQL Insufficient Memory Error

  1. Last updated
  2. Save as PDF

 


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


.