I have SQL 7 standard edition running on windows 2000 advanced server with 4 GB of ram and 4 processors. SQL Server is configured to use 2 GB (max allowed with this configuration?). But SQL SERVER only uses max of 1.7 GB; does anyone know why the other 0.3 GB is not being used?
I'm getting paging but SQL server shows 0.3 GB of memory free.
Thanks for any help you can offer.