Skip to content
«
»
 

Find Queries Using Most Memory (IO)

Posted by 
on  June 17 2009

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Find Queries Using Most Memory (IO)”.

Filed under DMV Queries
Comment (RSS)  |  Permalink

2 Comments

  1. Anandan Kanagarajan says:
    September 19, 2011 at 8:03 am

    High Memory usage of SQLSERVR.exe

    Server Configuration: Windows 2008 R2 server 64-bit; RAM – 4 Gigs; CPU 2.80 Ghz (2 processors); SQL Server 2008 32-bit has been installed.
    From the Task Manager, the Memory usage for the Sqlservr.exe is always showing as 3,390,168, i.e. almost 3.5 Gigs are being consumed by the sqlservr.exe.
    Is this a Normal? What are all the things to be checked?

    Reply to this comment
    • Derek Dieter says:
      September 19, 2011 at 10:06 pm

      Hi Anandan,

      Yes it is normal if you have the memory for SQL set that high. To change it open SQL Server Management Studio and connect to the server. Right click on the server name listed in the object explorer in the upper left hand corner -> properties -> memory -> (and set it here)

      Good luck

      Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»