High memory utilization on Server

• vinod.saraswat

  SSCrazy

  Points: 2395

  More actions

  August 30, 2011 at 4:37 am

  #242967

  Hi,

  We have set maxservermeroy to 55GB on SQL server instance. Now there is no application running on the server.

  I used sp_who2 all process are sleeping. Still the Task manager show high memory utilization. Attached is the result of following Query.

  select * from sys.dm_os_performance_counters

  where counter_name like '%memory%'

  But dont understand what they specifies.

  How to reduce the memory utilization. Not able to justify why the utilization is high.

  Thanks in Advance

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  August 30, 2011 at 5:58 am

  #1374905

  I don't wish to be rude here but why not try reading BOL, getting a basic intro to sql server book or even going on a training course.

  It saddens me that I've been seeing these exact same posts ( but with less memory way back 🙂 ) ever since sql server central started.

  To be blunt, if you allocate memory sql server takes it ( generally ) I bet you have lock pages enabled too ?

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/