SQL Server 2008 takes up a lot of memory?
- by Ahmed Said
I am conducting stress tests on my database, which is hosted on SQL Server 2008 64-bit running on a 64-bit machine with 10 GB of RAM.
I have 400 threads. Each thread queries the database every second, but the query time does not take time, as the SQL profiler says that, but after 18 hours SQL Server uses up 7.2 GB of RAM and 7.2 GB of virtual memory.
Is this normal behavior? How can I adjust SQL Server to clean up unused memory?