Hi & Help !

Im getting my memory counters all confused (must be an age thing !)

Ok if I understand correctly

Avaible bytes is the amount of memory availabe to SQL at that point in time
Working Set is the amount SQL is actual using

so far so good...

So is total server memory the same as avaible bytes.. ?! I dont understand !

On a box with 4gb in total .. with a fixed allocation of 3gb

I have
available bytes = 1.44gb
working set =  1.60 gb
total server = 1.58 gb


Help !

Simon

Hi Simon,

Available MB (it is the Memory object in Perfmon you are referring to?) is just that; how much physical memory is available in the OS.

Working Set (Process:Working Set: sqlservr.exe) is the part of the committed memory (which would then be Process:Private Bytes:sqlservr.exe) which is mapped to physical RAM.

Total Server Memory (SQL Server Memory Manager) is the amount of the committed memory used by the Buffer Pool (where all your data, procedure cache etc. goes).

This is a 32-bit box, right? When you say "fixed allocation" - do you mean "max memory" is set to 3 GB? Check with

sp_configure 'show advanced', 1

reconfigure with override

go

sp_configure 'max server'

go

sp_configure 'show advanced', 0

reconfigure with override

go

Max memory your (32-bit) SQL Server can use for the buffer pool (Total server memory) is aroud 1,7 GB unless you set the /3GB switch in boot.ini.

HTH!

/Elisabeth

---

Elisabeth Rédei | www.sqlserverland.com | MCITP, MCT | http://www.linkedin.com/elisabethredei