While collecting the baseline data through perfmon I had come across few basic doubts in my mind which I need to clarify with your help.
Suppose we have lot of RAM available and we launch an application (say a huge SSRS report with 5 million records). This takes up all the RAM and we see a steep decline in the perfmon chart. Once this report is generated , we notice a rise in the available
Does this means, the memory is released automatically by the report server? What is the concept behind this? Can we forcefully make SQL Server (or report server) to release the acquired memory at any point of time?
View Complete Post