I am doing performance analysis of SSRS reports (2008).
Before doing anything, I check in Task Manager(Performance tab) and see that my overall physical memory which is 8GB, is already divided between available memory and system cache. I have also setup perfmon counters and logging data for available memory counter.
Now when I launch a huge report with 2 million records, it starts consuming the available memory and I notice in Task Manager(Performance tab) the available memory is reducing BUT I also notice that the system cache is also reducing (I assume that perhaps
OS is borrowing memory from system cache to put it in available memory?) If my assumption is correct, then I would not be able to calculate how much physical memory my report used because it also includes a portion of system cache(?)
OR is the system cache reducing due to disk I/O?
This is getting confusing for me, please help me out experts.
View Complete Post