Thursday, September 17, 2009

Hardware configuration for SSIS and SSAS on SQL Server 2005 and SQL Server 2008

I'm reading: Hardware configuration for SSIS and SSAS on SQL Server 2005 and SQL Server 2008Tweet this !
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

No comments:

Related Posts with Thumbnails