Just trying to clarify a little.....
Your results of "total Avail Mem, KB" is the total available free space in the Mem-to-Leave VAS? and the "Max Free Size KB" is the largest block available?
So, if I have a startup parm of -g512
your query shows approximately 328 meg total avail mem, can I then assume my system is currently using approx 184 meg of mem-to-leave?
Also, does the PerfMon flag; PROCESS - PRIVATE BYTES - sqlserver
show me the current used mem-to-leave? (Which is just a little bit off from the formula above)
Thanks for the query and article!
Tim White