after installing SP4 on a 7.0 srvr w/ 2gig of ram, I noticed that the dynamic memory behaviour is different; i.e. sqlservr is only using around 86MB, down from 808MB with memory mgmt set to dynamic with no specified lower or upper limit (as it was before)

just curious if the list had any info on this phenomena -

thanks,

isaac /seattle