Its just an upper limit. SQL Server will try to use as much of the
memory as it can, very simliar to how NT will use as much of the
physical memory as it can for caching. Some of the caching that
SQL Server may have been using for caching, might not have been
used that often, therefore, you are not seeing a performance change
in the "often" used stuff.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart