Michael Entin's notebook

Michael Entin's notebook

Browse by Tags

Tagged Content List
  • Blog Post: SSIS custom component performance tidbit

    I was helping a friend of mine to debug performance issue with his SSIS package. The package was pretty simple – he needed to read data, shard it using some partitioning scheme, then insert the results into 8 SQL destinations. The hashing algorithm used for partitioning was rather complex for conditional...
  • Blog Post: Network causing SSIS package startup delays?

    This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in the context of SSIS service it has a KB article . But I still see forums posts and private questions that show that not all SSIS users are aware of it or realize that the same issue can cause SSIS package...
  • Blog Post: SSIS Backpressure Mechanism

    One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back pressure”. Let’s consider a simple package with a source and destination. What happens if the source is fast and destination is slow? Say source is huge local raw file and destination is a remote relational...
  • Blog Post: Katmai SSIS data flow task improvements

    With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and scalability improvements in this release. I'll assume readers are familiar with SSIS data flow performance concepts, if not make sure you've read these two articles: http://www.microsoft.com/technet...
  • Blog Post: SqlPerf blog on SSIS performance

    Runying Mao and Len Wyatt did a great study of SSIS performance, and posted some results: Getting Optimal Performance with Integration Services Lookups http://blogs.msdn.com/sqlperf/archive/2007/04/24/getting-optimal-performance-with-integration-services-lookups.aspx OLEDB Source with Views...
Page 1 of 1 (5 items)