MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, April 7, 2009

Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions

Sql Server 2008 having the additional features as I specified below.

1.SQL Server 2008- a record for loading data into a relational database using an Extract, Transform and Load (ETL) tool. Over 1 TB of TPC-H data was loaded in under 30 minutes.
2. 1.18TB of flat file data was loaded in 1794 seconds. This is equivalent to 1.00TB in 25 minutes 20 seconds or 2.36TB per hour.
3. Informatica has the fastest time previously reported, loading 1 TB in over 45 minutes. SSIS has now beaten that time by more than 15 minutes.
4.using sqlprofile task we can easily trace the data.

Carl Rabeler written excellent points about Sql Server 2008 Performance on his blog.

No comments: