If you are a blogosphere bee, you would definitely be knowing the new news of MS BI town. If no is the answer, keep reading ahead. If you are working on estimation of implementation of any ETL or Data warehousing solution, one is often confronted with the issues and questions about hardware estimation and sizing. As I had mentioned in my previous posts, Project Real implementation and the whitepaper published my microsoft on the project configuration where they loaded 1 TB in 30 mins, configuration can be nice-to-have reference points. But they are more inclined from a very high performance point and not from the aim of a typical production system.
HP has come out with a new set of whitepapers and a tool which they claim can help in making recommendations for the hardware configuration required for Data warehousing and ETL. Based on the features that the tool claims to provide, it seems to be nice tool and can really provide informed recommendations about the hardware configuration, and the greatest point is that the tool comes from the experts of hardware. On the product page of this tool, they claim that the tool would model configurations for:
1. ETL (Extract, Transformation, and Load) layer using SQL Server Integration Services
2. OLAP cube build using SQL Server Analysis Services
3. Queries accessing data used in a data warehousing ROLAP (Relational Online Analytical Processing) environment
4. Queries executed against OLAP cubes using SQL Server Analysis Services
Following downloads are available from the HP site:
HP Business Intelligence Sizer for Microsoft SQL Server 2005/2008
http://h71019.www7.hp.com/ActiveAnswers/us/en/sizers/microsoft-sql-bi.html
HP Whitepapers on SQL Server 2008 Data Warehousing / Business Intelligence
http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA2-5263ENW.pdf
http://h20195.www2.hp.com/V2/getdocument.aspx?docname=4AA2-8173ENW.pdf
http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA2-7162ENW.pdf
Reference: Benjami Wright Jones Blog
Article 
No comments:
Post a Comment