June 1, 2011 at 2:55 pm
In my new working company, I noticed in our environment, most of servers are sql 2005, sql server database engine and integration service are installed on one server, and sql 2005 Reporting service are installed on another server.
I guess this is for performance.
Other than that, any reasons to keep reporting service separate?
Now we have SQL server 2008, we don't have budget for another server to install reporting service, can we install reporting service together with database engine and ssis all in one machine, what are pro and cons for it?
I guess one pro is no need to buy another license and another hardware.
What about others?
Thanks
June 1, 2011 at 3:35 pm
Putting Reporting Services on a separate server will help performance, particularly is the reports are large. It also means that server resources on the database server are not shared with anything else. Another reason for separation with SQL 2005 was to remove the need for IIS to be installed on the database server (reducing potential vulnerabilities and patching)
SQL 2008 doesn't use IIS so separation is more about performance and reducing footprint on the database server. However, all of the SQL components can be put on one server if the databases and number of users are not huge.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply