I'm working on designing a SQL Server 2008 R2 Reporting Services (SSRS) topology, and a couple of my colleagues asked to see if SSRS can have its databases installed remotely, that is, separately from the other SSRS components. It looks like this is possible, but the question was also raised as to whether we could install it on our main OLTP db server.
1. My instinct tells me that this wouldn't be advisable for performance reasons, but is this feasible depending on the expected load for the SSRS installation?
2. Also, does it cost more in licenses to have SSRS host its own databases, or is the cost of an SSRS database instance for the ReportServer and ReportServerTempDB databases included in the license for the main OLTP db server that doesn't have SSRS on it? For example, according to this page, scaling out SSRS seems to increase the cost dramatically.http://www.networkworld.com/community/node/43349
3. That same article also suggests that it is best to separate the web server for SSRS as well, meaning at least one more server for that component. Is this really the necessary best practice across the board, or can it depend on the size of the expected user base of SSRS users (in our case, something like 20-30 users)?
Thanks for any help - I am in the middle of reading up on the related documents myself (for example here technet.microsoft.com/en-us/library/ms157293(v=sql.105).aspx
and here http://technet.microsoft.com/en-us/library/cc966418.aspx
), but thought I would put this question out there in case someone happens to provide information while I'm researching.
A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?