Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
It seems to me that your test is skewed. You're using two different servers, so how do you know that the server isn't the problem? My suggestion would be to test against the same server and compare the results. –  joeqwerty Apr 16 '10 at 11:34
1  
@joeqwerty Yeah you're right. I re-created the test on another Windows 2003 server and client combo, and did not see the same slow results. I guess the answer to my question is "no; it should be the same" –  nbolton Apr 16 '10 at 13:44
add comment

1 Answer

up vote 0 down vote accepted

It appears that the answer is no; it performs just the same.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.