Dedicated reporting server?...
Page 1 of 1 • Share •
Dedicated reporting server?...
I am seeking advice. Consider: Distributed data warehouse, consisting of multiple dimensional marts, on multiple servers, Windows, MS SQL, Cisco net.
The largest mart is 300 GB, the smallest is 50 GB. Nightly ETL (Informatica), the availability SLA is 12x5, but it's more like 16x7.
Introducing SSRS/SSAS. There will be multiple "dashboards", with multiple reports, ROLAP and MOLAP cubes, etc.
Assuming these dashboards and cubes will be using/relying upon the data from multiple marts, do I build a dedicated "reporting" server to carry these dashboards and cubes, or do I deploy the dashboards on the same servers that the marts are on? I am leaning more toward the dedicate SSRS reporting server, but am far from certain I am doing the right thing.
What does everyone think?
The largest mart is 300 GB, the smallest is 50 GB. Nightly ETL (Informatica), the availability SLA is 12x5, but it's more like 16x7.
Introducing SSRS/SSAS. There will be multiple "dashboards", with multiple reports, ROLAP and MOLAP cubes, etc.
Assuming these dashboards and cubes will be using/relying upon the data from multiple marts, do I build a dedicated "reporting" server to carry these dashboards and cubes, or do I deploy the dashboards on the same servers that the marts are on? I am leaning more toward the dedicate SSRS reporting server, but am far from certain I am doing the right thing.
What does everyone think?
SuperPindos- Posts : 1
Join date : 2013-06-09

» we are renting with dedicated server co-lo in USA & UK
» ..::Dedicated server Rent With Voip Switch::..
» VPS with relay server based PC2Phone & mobile dialer at $499
» HOW TO RUN SERVER AUTOMATICALLY IN ECLIPSE USING SELENIUM RC
» Selenium RC with Google Chrome on Windows server 2008
» ..::Dedicated server Rent With Voip Switch::..
» VPS with relay server based PC2Phone & mobile dialer at $499
» HOW TO RUN SERVER AUTOMATICALLY IN ECLIPSE USING SELENIUM RC
» Selenium RC with Google Chrome on Windows server 2008
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum