I have SQL Server Express on my VPS(2GB RAM) with a database size of 1.5 GB that I expect will increase to 15 GB. I have noticed that SQL Server is using 1.5 GB RAM even when only small queries has been run against the database.
Is there any relation between memory and database size? Can I tune my SQL Server so it can handle memory better and not use as much memory as it does now?
Here is the memory status of SQL Server:
VM Reserved,1455488 VM Committed,19320 AWE Allocated,0 Reserved Memory,1024 Reserved Memory In Use,0