July 18, 2014 07:35 by
BenReporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enables developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.
Today we're going to cover how to configure available memory for SQL Server Reporting Services 2014. If you need to configure the amount of memory available to an instance of SSRS 2014 you have to get your hands dirty and edit the RsReportServer.config file. The RsReportServer.config file stores settings that are used by Report Manager, the Report Server Web service, and background processing.
The location of the rsconfile file is generally:
\Program Files\Microsoft SQL Server\MSRS1111.MSSQLSERVER\Reporting Services\ReportServer
Within the RsReportServer.config file, configuration settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum, MemorySafetyMargin, and MemoryThreshold. If you were to open the file you will see that the WorkingSetMinimum and WorkingSetMaximum are not present by default.
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemorySafetyMargin>80</MemorySafetyMargin>
<MemoryThreshold>90</MemoryThreshold>
<RecycleTime>720</RecycleTime>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
This is because you have to enter them yourself, as if you are hosting multiple applications on the same computer and you determine that the report server is using a disproportionate amount of system resources relative to other applications on the same computer.
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemorySafetyMargin>80</MemorySafetyMargin>
<MemoryThreshold>90</MemoryThreshold>
<RecycleTime>720</RecycleTime>
<WorkingSetMaximum>786432</WorkingSetMaximum>
<WorkingSetMinimum>524288</WorkingSetMinimum>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
The Reasons To Use SQL Reporting Service (SSRS) 2014 Hosting with ASPHostPortal.com
- Fully Integrated with SharePoint
- The report development environment is a Standard Microsoft Platform - SSRS Reports are developed in BIDS (Business Intelligence Development Studio).
- Customizable Report Rendering - SSRS provides a .NET Web Service programmatically accessible to extend the delivery of reports beyond the browser. The SSRS reports can be rendered to HTML. PDF(Portable Document Format), Microsoft Excel, XML, MHTML (MIME HTML), TIFF (Tagged Image File Format). Microsoft Word, and ATOM. The SSRS .NET Web Service allows embedding reports in custom applications where the look and feel of the report viewer can be easily controlled and customized.
- Mobile Support - Starting SQL Server 2012 Service Pack 1 (SP1), SSRS supports viewing and basic interactivity with reports on Microsoft Surface devices and devices with Apple iOS6 and Apple Safari Browser such as iPAD. SSRS reports can also be view on Windows 8 devices.