Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 High memory utilization for sql server reporting s

Author  Topic 

anoop_mig25
Starting Member

20 Posts

Posted - 2015-03-26 : 13:15:26
HI freinds

We have two server configured in always on mode .
windows is sql server 2012 64 bit edition
and sql server is 2012 64 bit edition

RAM installed on both server is around 65 gb of which 49 gb is max server memory allocated for sql services on both servers

database related to reporting services are also in always on group

We have also configured for reporting services and both are running on their respecting server

Issue is on primary server reporting service is using almost 7 gb while on secondary it is using 10 gb even when there are 5 reports and its used within offices

what issue and how to check why ssrs is using high memory..

any query , perfmon counters

reports are randomly used at client side

i have checked memory utilization through task manger..
please help

regards
Anoop
   

- Advertisement -