Different Drivers for SQL Sever
Posted: Sat Feb 28, 2015 4:22 pm
Hi,
We are on Information Server 9.1 on Windows, using Server Jobs
and the DB is on SQL Server 2012 server
I see different drivers to connect to SQL Server like
IBM Native SQL Server Wire Protocol 7.10.03.128
IBM SQL Server Wire Protocol 7.10.02.19
SQL Sever 6.01.7601.17514
When we migrated from V7.5 to V9.1, we are seeing a 50-60% performance degradation for exactly the same jobs. All compiled successfully and are running fine without any failures but a lot slower
I understand we should expect ~ 10% slow down due to the way Authentication works in 9.1 v 7.5
Our testing indicates the SQL read/write is where the major performance loss is and on contacting IBM they recommended we use ODBC Connector instead of the ODBC Stage. This change did not help much
We have been using the SQL Server Native driver, is using the IBM provided drivers recommended? We will try that as well, but if any one has already used these or any other direction/pointers will be helpful
Thanks,
NV
We are on Information Server 9.1 on Windows, using Server Jobs
and the DB is on SQL Server 2012 server
I see different drivers to connect to SQL Server like
IBM Native SQL Server Wire Protocol 7.10.03.128
IBM SQL Server Wire Protocol 7.10.02.19
SQL Sever 6.01.7601.17514
When we migrated from V7.5 to V9.1, we are seeing a 50-60% performance degradation for exactly the same jobs. All compiled successfully and are running fine without any failures but a lot slower
I understand we should expect ~ 10% slow down due to the way Authentication works in 9.1 v 7.5
Our testing indicates the SQL read/write is where the major performance loss is and on contacting IBM they recommended we use ODBC Connector instead of the ODBC Stage. This change did not help much
We have been using the SQL Server Native driver, is using the IBM provided drivers recommended? We will try that as well, but if any one has already used these or any other direction/pointers will be helpful
Thanks,
NV