SSIS性能 - 救援的SQLCAT

进行常规SQL培训课程的危险之一是您在Sample AdventureWorks自行车公司数据库中绑定。它比原来的酒吧（出版不饮酒）和Northwind数据库更加现实，其中一些表有100,000多行，但与典型的客户数据库相比，它是苍白的。因此，当我被问到大数据库性能时，我最喜欢的网站是http://www.sqlcat.com。SQL客户咨询团队是一个伟大的Microsoft倡议，其中有一个经验丰富的顾问团队，使用最新的SQL Server进入高调的客户网站，并帮助他们成功。副产品是顾问发布SQL Server白皮书和基于使用最大数据库的真实客户解决方案的最佳实践。许多次SQL Server开发人员也涉及，因此产品本身随着时间的推移而受益。Microsoft在鼓励新客户时可以点击此资源。这是我们所有使用SQL Server的双赢的局面。我最近在科罗拉多州的丹佛的客户网站上教授商业智能课程。外面它是减去14华氏度。 Inside we had some heated discussions on comparing SSIS with other ETL tools such as Informatica. SQL Server 2000 DTS was always rated as a light-weight ETL tool but SSIS has been re-written using .NET and has some great scalability features. But using my rinky-dink laptop with AdventureWorks was not a proper test. In fact performance was poor mainly because I had everything loaded on one machine including Active Directory, Sharepoint, Exchange, SQL Server, SSAS, SSRS and SSIS. Definitely a no-no with 2GB RAM. Must build some new VMs over the holidays. SQLCAT.com to the rescue! Listed is their TOP 10 SQL Server Integration Services Best Practices. For instance, it is clear that SSIS should run on a separate machine, even separate from SQL Server itself for maximum performance. Partitioning recommendations, network, CPU and Memory too and how to identify particular bottlenecks in your SSIS packages. Great stuff. http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx In the article, they state that SQL Server Integration Services can process at the scale of 4.5 million sales transaction rows per second. That's pretty impressive and constitutes an unofficial world record, faster than Informatica apparently. Unfortunately, there is no official TPC benchmark for ETL yet. Something for the wish list for 2010 me thinks. Happy Holidays! Brian