• 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