How to identify how much memory SQL is using, outside of the buffer pool

• winston Smith

  SSCoach

  Points: 19500

  More actions

  February 21, 2012 at 1:51 am

  #257070

  I have a server with 32GB of RAM. My instance is configured to use 27GB of ram, leaving 5 for the OS. When i check task manager though i can see sql server has a private working set of almost 30GB.

  Im guessing most of this RAM is for items outside of the buffer pool (which is all that the max memory setting specifies).

  How do i figure out what exactly sql server is using this extra memory for?

• sengeet86

  Ten Centuries

  Points: 1252

  More actions

  February 21, 2012 at 3:29 am

  #1449549

  Check this bog on this.

  http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx

  java programming