0

We are running SQL server SQL 2014 12.0.2000.8 32 bit running on Windows 2008 server 32 bit.

This server is also part of T-Replication as a publisher and also distributor.

The server has 16 GB of RAM and has allocated Max Memory 2147483647 MB (Default setting) to SQL server.

Since yesterday I am getting the below error whenever start the SSMS. To solve it, I restarted SQL Server Service, then I am able to login to SQL Server, but after a few hours it happens again.

enter image description here

Please provide me help with any idea where to look to trouble shoot the issue.

  • Start with this Q&A "When should I not set the maximum memory in SQL Server" – LowlyDBA Dec 28 '17 at 13:42
  • SQL Server 2014 is not supported on Windows server 2008. Plus your SQL Server 2014 is not even patched to latest service pack. Moreover you can solve this issue by using 64 bit of both SQL Server and Windows OS – Shanky Dec 29 '17 at 9:13
  • I add service pack 2(now my Sql Server is 12.0.5000.0).But i can't use 64 bit OS because PIKA(telephonic card) card is not supported 64 bit OS this is our limitation. – Gulrez Khan Jan 2 '18 at 7:22
1

This is usually down to memory pressure, I assume that you're running SSMS on the SQL server? Try opening SSMS from another location and connect in, does this still produce the error?

You might want to set your max memory setting to allow some breathing space for the OS and other apps. I usually leave the OS 4GB to start with and then tune from there if I need to.

|improve this answer|||||
  • I add service pack 2(now my Sql Server is 12.0.5000.0).But i can't use 64 bit OS because PIKA(telephonic card) card is not supported 64 bit OS this is our limitation. – Gulrez Khan Jan 2 '18 at 7:23
0

If your Windows Server 2008 is Standard 32bit then the max memory is 4GB. If it is enterprise or data center then the max memory for 32 bit 64GB.

I do agree with David that you have memory pressure.

Here is a link to server memory limits https://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx

|improve this answer|||||
  • Actually the max memory which SQL Server can utilize under default condition would be 2 GB. The total VAS is 4 GB equally divided between SQL Server and OS. – Shanky Dec 29 '17 at 9:11
0

I don't know what your CLR code is doing, but I think your problem is described here: https://support.microsoft.com/en-us/help/106167/error-message-not-enough-server-storage-is-available-to-process-this-c

Solution is also included in the link.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.