Performance Testing the Microsoft OLE DB Provider for DB2 (Part 3)

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…

1

Performance Testing the Microsoft OLE DB Provider for DB2 (Part 2)

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 over SSIS, when moving data from DB2 to SQL Server.   Initially I did…

1

Performance Testing the Microsoft OLE DB Provider for DB2 (Part 1)

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 speed, memory, # of CPUs, loads (on DB2 or SQL). There are way too many factors to…

0