Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2007-11-05 : 09:53:07
|
| I've been reading quite a bit on Reporting Services and most of the articles I've read talk about 'the reporting server'. Is it a good idea to have a separate server for handling the reporting?If I wasn't to use a separate server for reporting what would be the implications? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-05 : 10:30:14
|
| The reporting server" could mean at least 2 things. An IIS web server to serve up the report, and a sql db server to hold report definition and data about reports. The data used for the reports could be in the OLTP if the workload is not too heavy, or in a sepereated db just for reporting use only. So, depends on which "server" you are talking about, the consideration is different. |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-05 : 10:53:14
|
We install reporting services on web servers separate from the database server, for one it is not a good idea to have IIS on your SQL Server box. We do create the reporting databases on the the same instance as our application databases.
Future guru in the making. |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2007-11-06 : 06:43:40
|
| Thanks for the feedback. I'll take your points into consideration. |
|
|
|
|
|
|
Reporting services