Is ODBC on Windows 2003 slower than on Windows 7?

Posted by nbolton on Server Fault See other posts from Server Fault or by nbolton
Published on 2010-04-16T11:08:41Z Indexed on 2010/04/16 11:13 UTC
Read the original article Hit count: 334

I am seeing some MSSQL 2005 performance issues, and I am trying to diagnose the cause. I am using SQL profiler to gather query execution times. Both the client (using ODBC), and the SQL server are running on Windows 2003. I am also using Windows 7 (client) with a different Windows 2003 server to compare results.

Windows 7 client / Windows 2003 server:

  • SQL management studio: 393ms
  • Through ODBC: 215ms

Windows 2003 client:

  • SQL management studio: approx 155ms
  • Through ODBC: 3145ms

... in both cases, I'm running SQL management studio on the client. To me, these figures suggest there's something wrong with the ODBC client on the Windows 2003 server.

On Windows, I see that the ODBC "SQL Server" driver is version 6.01.7600.16385 but on Windows 2003, it is 2000.86.3959.00 (by default). Could this be the problem? Is it possible to update an ODBC driver?

© Server Fault or respective owner

Related posts about odbc

Related posts about sql-server-2005