August 10, 2013 at 12:43 pm
Hi friends at one of our client side we have 4 sql server instances one default and 3 named installed on a single physical server box. It has 32GD ram. 8,8,8,and 4 GB of memory is allocated to sql server.
Sometimes memory consumption reaches upto 30/31 gb and i am not able to determine what is eating out memeory.
It is not queires because i had use sysprocess and always got random query.
Plz help to find out what is consuming memory.Plz tell me where to look for it.what to look for it.which queries/dmvs to use
August 10, 2013 at 1:00 pm
SQL uses memory outside of the buffer pool (which is what max server memory sets). Nothing wrong, this is normal behaviour, however you cannot set how much extra. It's usually small, couple hundred MB, however if you have lots of connections or use lots of linked servers or have memory-hogging CLR it can be larger
If SQL is using too much memory, reduce max server memory as that is the part you can control.
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