Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow SQL Server in WIN 2000
Message
From
21/04/2002 10:08:29
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00604404
Message ID:
00647330
Views:
18
>I'm really grasping here. Are there performance issues when executing activities that do not involve accessing SQL Server? Loading a Word document for instance?
>
>I'm wondering if something screwy with MDAC installed on the machine. It might be worth uninstalling whatever version is on there and reinstalling MDAC 2.6.
>
>http://support.microsoft.com/support/MDAC/26setupfaq.asp#26setupfaq
>
>You'll have to have a Windows 2000 CD to do the removal.
>
>-Mike

Mike,

This is the old, old, old, old business department. I decided to use one of my MSDN "incidents" on this problem. Over the course of the last few months, we had two different 'SQL Engineers' assigned to the case, and we sent in many megabytes of log files.

Finally, several days ago, the woman at Microsoft handling the case asked Dave if he had ODBC tracing turned on (the 'Tracing' tab on the ODBBC Data Service Administrator). He did. When he turned it off, the problem went away.

As we had played with this, I became quite certain it was not a SQL Server issue -- it was really the SQL desktop tools' slowness in accessing any server -- on his laptop or over the network.

Thanks for your help. Just wanted to close the loop.

Best regards, Steve
Previous
Reply
Map
View

Click here to load this message in the networking platform