December 29, 2006 at 10:36 am
I am looking for help in determining the best approach - the pros and cons of that aapproach. There are 2 things I am considering which will help determining the best method: 1) performance, network bandwidth 2) clustering and HA/DR
I have an OLTP application that is being used constantly throughout the day (using 4 databases) and I require to provide reporting services to create and run automated and Adhoc reports - how is it best to set this configuration up:
Load reporting services db on the same server as the primary database for the applications - if yes - does this give better performance than if it were on a separate server (considering the source data location)? If no - (would I need additional licencing) and how much processing and net bandwidth would be used for the db cross communications? - I am working under the assumption that I will have the IIS part on a separate web server (or farm).
In the above scenario - If I were running a cluster would there be an advantage or disadvantage of running the reporting services on node 2 and the app databases on node 1 ? (ie active/active) - or would it be better - all on one node (active/passive) - any good reasons for doing either ?
Finally - if I were running transactional replication from the primarary server (for the applications databases) onto a DR server , what would be the best approach to have DR capabilities for the reporting services ( a second copy on the DR server - or also use replication - I dont think I can do that - but wanted to ask anyways.
If anyone has any pointers, comments or reference links that can help me research the good and bad aspects of this I would very much appreciate it.
Thanks in advance.
** What you see, Depends on what you Thought, Before, You looked! **
January 1, 2007 at 8:00 am
This was removed by the editor as SPAM
January 3, 2007 at 11:18 am
Absolutely any information of links that may help me determine a good configuration will be of help - I just dont want to go down the path and then find out later that there were some extra considerations I should have taken before implememntation. If you see any gotcha's in the config that I should be aware of I would certainly appreciate that too. Thanks.
** What you see, Depends on what you Thought, Before, You looked! **
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply