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.
| Author |
Topic |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2015-03-26 : 13:15:26
|
| HI freindsWe have two server configured in always on mode . windows is sql server 2012 64 bit editionand sql server is 2012 64 bit editionRAM installed on both server is around 65 gb of which 49 gb is max server memory allocated for sql services on both serversdatabase related to reporting services are also in always on group We have also configured for reporting services and both are running on their respecting serverIssue 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 countersreports are randomly used at client sidei have checked memory utilization through task manger..please helpregardsAnoop |
|
|
|
|
|
High memory utilization for sql server reporting s