February 23, 2015 at 11:33 am
Hi,
I am hoping someone can hep me understand how SSRS handles memory. What I would like to know is if the maximum memory settings in SQL server pertains to the reporting services. Specifically if a server has 64GB of RAM and I set the max memory to 60,000MB, does that mean there are only about 4GB to run reports and the OS or does this setting include the reporting service? I ask because we have been seeing some server throw the exception above when running some reports, and sometimes the reporting service is consuming %100 of the CPU, in which generally no reports run at that point.
I have read this page, but I'm still not clear. Any help is appricated, thanks.
https://msdn.microsoft.com/en-us/library/ms159206(v=sql.110).aspx
Most recent error:
processing!ReportServer_0-18!dc8!02/23/2015-11:55:27:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.ReportIntermediateFormat.Sorting' threw an exception. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportIntermediateFormat.Sorting..cctor()
--- End of inner exception stack trace -
March 12, 2015 at 7:45 am
MS SQL Server max memory does not include reporting services.
Total memory-MS SQL Server max memory= memory for OS, SSRS, SSAS, SQL Agent, SSIS, other applications
March 12, 2015 at 8:16 am
Thank you. Since the incident I have lowered the max memory threshold in SQL and so far it's been working better. I also upped the threshold cost for parallelism to increase the likelihood of available threads.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply