Hello Experts, I am using sql server2008r2 entp version Received alert : Percentage of Committed Memory in Use is too high from task manager noticed my sql is consuming more memory (e.g 50 gb ) of the box then what are the steps to encounter the issue? from where to start? which commands are there? can you please help?
you are using sQL Server 32 Bit or 64 bit? if you are using 64 bit then it is a regular habbit of SQL Server 64 bit server, **set the max memory for better performance of the server** have a look into the Available MBytes of the Server they should be 10% of the installed RAM, if they are at 100MB, then it might be memory leak