In Part 1 of this series I covered testing SQL queries using the Microsoft OLE DB Provider for DB2 using a linked server. In Part 2 I showed how you can test performance with SSIS. However, in many cases, customers may be using C# or VB.NET, writing web services or stand-alone applications to query DB2...

Technorati Tags: Data Providers , DB2 , Host Integration Server , Microsoft OLE DB Provider for DB2 , OLEDB , Performance , SSIS , SQL Server In my previous entry, I covered testing SQL queries using the Microsoft OLE DB Provider for DB2 using a linked server, but many customers really need to test performance...

Technorati Tags: DB2 , SQL Server , SSIS , Microsoft OLE DB Provider for DB2 , Host Integration Server , Data Providers , Performance , OLEDB There are many factors that can affect pulling data from DB2 into SQL Server (or other applications). These include the network speed, hard drive; machine CPU...