Ron Dokken
asked on
SQL 2012 Reporting Services, high memory consumption - turn it off?
I've got me a computer with SQL 2012.. Reporting Services is eating away all the RAM. As far as I know, no application is using reporting services. Can I turn it off / disable it?
If so, how?
If so, how?
Bembi
You can stop the SQL Reporting server service and set it on manual start or disabled
To turn on or off the Report Server Web service by editing configuration
1. Open the RsReportServer.config file in a text editor. For more information, see Modify a Reporting Services Configuration File (RSreportserver.config, located at C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\
2. To turn on the Report Server Web service, set IsWebServiceEnabled to true:
3. <IsWebServiceEnabled>true<
4. To turn off the Report Server Web service, set IsWebServiceEnabled to false:
5. <IsWebServiceEnabled>false
6. Save your changes and then close the file.
To turn on or off the Report Server Web service by using SQL Server Management Studio
1. Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.
2. In Object Explorer, right-click the Reporting Services node, point to Policies, and click Facets.
3. In the Facet list, select Surface Area Configuration for Reporting Services.
4. Under Facet Properties:
o To turn on the Report Server Web service, set WebServiceAndHTTPAccessEna
o To turn off the Report Server Web service, set WebServiceAndHTTPAccessEna
5. Click OK.
1. Open the RsReportServer.config file in a text editor. For more information, see Modify a Reporting Services Configuration File (RSreportserver.config, located at C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\
2. To turn on the Report Server Web service, set IsWebServiceEnabled to true:
3. <IsWebServiceEnabled>true<
4. To turn off the Report Server Web service, set IsWebServiceEnabled to false:
5. <IsWebServiceEnabled>false
6. Save your changes and then close the file.
To turn on or off the Report Server Web service by using SQL Server Management Studio
1. Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.
2. In Object Explorer, right-click the Reporting Services node, point to Policies, and click Facets.
3. In the Facet list, select Surface Area Configuration for Reporting Services.
4. Under Facet Properties:
o To turn on the Report Server Web service, set WebServiceAndHTTPAccessEna
o To turn off the Report Server Web service, set WebServiceAndHTTPAccessEna
5. Click OK.
To stop the SSRS using Reporting Services Configuration
On the Report Server Status page, click Stop or Start.
Stop SSRS using Administrative Tools
If you are running multiple instance or if the report server is running as a named instance, verify that the instance name in parentheses corresponds to the report server instance you want to stop.
To stop the SSRS using SQL Server Configuration Manager
Select SQL Server Services, right-click SQL Server Reporting Services, and click Stop or Restart.
http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx
On the Report Server Status page, click Stop or Start.
Stop SSRS using Administrative Tools
If you are running multiple instance or if the report server is running as a named instance, verify that the instance name in parentheses corresponds to the report server instance you want to stop.
To stop the SSRS using SQL Server Configuration Manager
Select SQL Server Services, right-click SQL Server Reporting Services, and click Stop or Restart.
http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx
ASKER
So what is best practice in case you don't need reporting services?
Please follow the url to turn report features off.
Mmh, a lot of stuff to switch off just a service...
If you want to permanently switch it off, you have to set the start type to manual or disabled..
If you use service manager or SQL configuration manager has the same result...
So there is no "best practice"
If you don't need the service at all, uninstall the reporting service feature, so you can even save some bytes on the disc.
If you want to permanently switch it off, you have to set the start type to manual or disabled..
If you use service manager or SQL configuration manager has the same result...
So there is no "best practice"
If you don't need the service at all, uninstall the reporting service feature, so you can even save some bytes on the disc.
So what is best practice in case you don't need reporting services?Not installing it. Why did you install it if you won't need it?
By the way, recommendation is to install Reporting Services in a dedicated server. Same recommendation for SQL Server Engine. The main reason is to avoid issues like you're having now (share the same computer resources).
ASKER
>>Not installing it..
I see :) Since it's now installed, do you agree with HuaMinChen?
I see :) Since it's now installed, do you agree with HuaMinChen?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
>> Don't forget to set it to manual service so it won't start automatically..
Why not disabled?
Why not disabled?
Why not disabled?Whatever the option is but not automatic.
ASKER
You can choose Automatic, Manual or Disabled. Are we sure SQL Server never needs Reporting Services when no application is using it?
In other words, is it safe to disable it completely?
In other words, is it safe to disable it completely?
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
If you put it on manual, it will not start during reboot. But it can be started if any other service forces the Reporting Service to start.
If you disable it, it will not start, even another service tries to force a start.
Reporting services is a tool to visualize reports crated there via a Web Browser.
SQL (by default) doesn't need nor use Reporting Services, the Reporting services are usually used by applications, which also store there data in a SQL Server database.
So, if you stop the service (and set it to manual or disabled) you can observe the server, if you get SQL Reporting Services related errors. This way you may even find out, it there are any other applications, which make use of reporting services.
Nothing will explode, in the worst case you see some event log messages and maybe error messages in other applications.
You can also open the Reporting Services web site so see, if there are any reports there. If not, you can assume, that it is not used.
If you disable it, it will not start, even another service tries to force a start.
Reporting services is a tool to visualize reports crated there via a Web Browser.
SQL (by default) doesn't need nor use Reporting Services, the Reporting services are usually used by applications, which also store there data in a SQL Server database.
So, if you stop the service (and set it to manual or disabled) you can observe the server, if you get SQL Reporting Services related errors. This way you may even find out, it there are any other applications, which make use of reporting services.
Nothing will explode, in the worst case you see some event log messages and maybe error messages in other applications.
You can also open the Reporting Services web site so see, if there are any reports there. If not, you can assume, that it is not used.
ASKER
Nice but too late :)