THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

SQL Server Memory Tracking with Windows Task Manager

Have you ever looked at the Windows Task Manager for a quick read on SQL Server 2005 memory consumption?

 

You can get good information from the Windows Task Manager about SQL Server memory, but you have to know what to look for. When running with AWE memory enabled on a 32-bit system, you may see an unusually low amount of memory in the Windows Task Manager.  If AWE is being used, you will probably get a much better idea of how much AWE memory is being consumed by checking page file usage.  The page file usage value and the amount of AWE memory will correspond.

 

You can then cross-check this value against sys.dm_os_sys_info.bpool_committed for the exact value.

 

(Thanks to Geoff N. Hiten, the "SQL Craftsman", and Erland Sommarskog for the tip.)

Published Friday, August 29, 2008 6:01 PM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

AaronBertrand said:

This is a pretty common problem out there... about once a week I see someone in the newsgroups complain that SQL Server isn't using enough memory.  I always tell them to use the DMVs or PerfMon instead of Task Manager, as it usually turns out to be this exact scenario - they haven't experienced any symptoms that make them think SQL Server isn't getting enough memory, they just believe what the process list in Task Manager tells them.

August 30, 2008 12:22 PM
 

jchang said:

this also occurs with full 64-bit OS & SQL

August 30, 2008 1:56 PM
 

Greg Linwood said:

A far more common problem I've noticed is where SQL2K Std Edn is only using 1.6Gb on a server with 2Gb or more RAM & even though the system is crawling, the sysadmin assumes the server has enough memory b/c it's not using it all..

August 30, 2008 6:07 PM
 

KKline said:

Excellent comments, guys.  Thanks!  -Kev

September 2, 2008 5:54 PM

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement