October 1, 2015 at 7:23 am
Hi folks,
ON my production server, I have 16 GB RAM and I have configured it as ,
min:512 MB
max:13500 MB
but more often I have noticed that we are getting low memory issues. Qhen I check the task manager it shows 20GB memory being used by ssms.exe.
I cannot understand this . please clarify how am i getting 20GM memory usage when only 13500MB is allocated to SQL svr.
Also please help me in getting rid of the low memory issues.
October 1, 2015 at 10:27 am
1) Don't use Task Manager to check SQL Server's memory, it can be wrong
2) SSMS is not the SQL Server engine. It's SQL Server Management Studio. It shouldn't be getting used on a production server. Especially not to query large resultsets which will cause it to use physical memory and page file if necessary
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply