We are using SQL server 2008 in Windows Server 2008 R2 and Ram is 32 GB. When we check in the Windows Task manager 25GB is always occupied even though no one is accessing the server.
Around 10 clients connected to the server. When we run a report from application, (2 or more clients runs it simultaneously) the memory occupied fully ie 32 Gb and saving records from other application got failed.
I checked in RAMmap tool AWE occupies 25 GB.
How to handle this situation? ie., how to limit the usage of memory for SQL server or adding records when the report query takes long time to run? Thanks