I am configuring a new environment to run several intranet web applications. I have 2 servers, one will be the SQL Server 2008 server, and the other will be the IIS server. I also need to install SQL Server Reporting Services. I am not sure whether it would be better to run reporting services on the database server, or web server. Is there a best practice for this situation?
我正在配置一个新环境来运行多个Intranet Web应用程序。我有2台服务器,一台是SQL Server 2008服务器,另一台是IIS服务器。我还需要安装SQL Server Reporting Services。我不确定在数据库服务器或Web服务器上运行报告服务是否更好。这种情况有最好的做法吗?
2 个解决方案
#1
Depends...
The reporting services rendering is fairly processor intensive so you need to keep that in mind. Typically if I'm designing a system with heavy load or throughput requirements I place the reporting services instance on its own server. The best practice is really dependent on the complexity of your system.
报告服务呈现相当处理器密集,因此您需要牢记这一点。通常,如果我正在设计一个负载或吞吐量要求很高的系统,我将报告服务实例放在自己的服务器上。最佳实践实际上取决于系统的复杂性。
If a third server is not an option and the two servers you already have are similarly speced I would probably place it on the one with the lowest processor load. If you place the reporting server on the web server make sure that Reporting services uses your dedicated database server for the reporting services meta-data so that you don't have to install the RDBMS on both machines.
如果第三个服务器不是一个选项,并且您已经拥有的两个服务器具有类似的速度,我可能会将它放在处理器负载最低的服务器上。如果将报告服务器放在Web服务器上,请确保Reporting Services将您的专用数据库服务器用于报告服务元数据,这样您就不必在两台计算机上安装RDBMS。
You need to keep in mind that if you don't place the reporting server on the same box as SQL server you will need another SQL Server license. The product is only "free" if it is installed on the same machine as SQL.
您需要记住,如果不将报表服务器放在与SQL Server相同的框中,则需要另一个SQL Server许可证。如果产品与SQL安装在同一台机器上,则该产品仅“免费”。
#2
I would run installer on your web server so that the web service components of Reporting Services are installed there.
我会在您的Web服务器上运行安装程序,以便在那里安装Reporting Services的Web服务组件。
It is also benificial to configure reporting services with it's own application domain in IIS so that you can tweak the configurations independant of say your other web applications.
在IIS中使用自己的应用程序域配置报告服务也是有益的,这样您就可以调整与您的其他Web应用程序无关的配置。
When you run through setup using the Reporting Services Configuration Tool, set up the database on your non web server (i.e. dedicated db server). This way all your data processing is handled on one server and all your web processing/data rendering is handled on another.
使用Reporting Services配置工具运行安装程序时,请在非Web服务器(即专用数据库服务器)上设置数据库。这样,您在一台服务器上处理所有数据处理,并在另一台服务器上处理所有Web处理/数据呈现。
Hope this is clear and of use but please feel free to pose further questions.
希望这是明确的和有用的,但请随时提出进一步的问题。
Cheers,John
#1
Depends...
The reporting services rendering is fairly processor intensive so you need to keep that in mind. Typically if I'm designing a system with heavy load or throughput requirements I place the reporting services instance on its own server. The best practice is really dependent on the complexity of your system.
报告服务呈现相当处理器密集,因此您需要牢记这一点。通常,如果我正在设计一个负载或吞吐量要求很高的系统,我将报告服务实例放在自己的服务器上。最佳实践实际上取决于系统的复杂性。
If a third server is not an option and the two servers you already have are similarly speced I would probably place it on the one with the lowest processor load. If you place the reporting server on the web server make sure that Reporting services uses your dedicated database server for the reporting services meta-data so that you don't have to install the RDBMS on both machines.
如果第三个服务器不是一个选项,并且您已经拥有的两个服务器具有类似的速度,我可能会将它放在处理器负载最低的服务器上。如果将报告服务器放在Web服务器上,请确保Reporting Services将您的专用数据库服务器用于报告服务元数据,这样您就不必在两台计算机上安装RDBMS。
You need to keep in mind that if you don't place the reporting server on the same box as SQL server you will need another SQL Server license. The product is only "free" if it is installed on the same machine as SQL.
您需要记住,如果不将报表服务器放在与SQL Server相同的框中,则需要另一个SQL Server许可证。如果产品与SQL安装在同一台机器上,则该产品仅“免费”。
#2
I would run installer on your web server so that the web service components of Reporting Services are installed there.
我会在您的Web服务器上运行安装程序,以便在那里安装Reporting Services的Web服务组件。
It is also benificial to configure reporting services with it's own application domain in IIS so that you can tweak the configurations independant of say your other web applications.
在IIS中使用自己的应用程序域配置报告服务也是有益的,这样您就可以调整与您的其他Web应用程序无关的配置。
When you run through setup using the Reporting Services Configuration Tool, set up the database on your non web server (i.e. dedicated db server). This way all your data processing is handled on one server and all your web processing/data rendering is handled on another.
使用Reporting Services配置工具运行安装程序时,请在非Web服务器(即专用数据库服务器)上设置数据库。这样,您在一台服务器上处理所有数据处理,并在另一台服务器上处理所有Web处理/数据呈现。
Hope this is clear and of use but please feel free to pose further questions.
希望这是明确的和有用的,但请随时提出进一步的问题。
Cheers,John