We have a physical machine with Win 2008R2. 16 GB RAM. Half of the memory is allocated to SQL Server database engine (9 GB). However other SQL Services like SSIS, SSRS and SSAS are also installed on that server.
Total memory usage has spiked upto 95%. How do i figure out what is eating away this memory. And how much memory is being consumed by SSIS SSAS and SSRS? Thanks in advance.