?
Solved

ODBC Based SQL query appears to be "throttled"

Posted on 2004-08-28
2
Medium Priority
?
292 Views
Last Modified: 2010-03-18
I'm pulling my hair out on this one...

I keep a Delphi 7 development at a client's site.  I have a SQL query tool  that  built in Delphi, using ODBC connection to Sybase and MS SQL.  It has worked flawlessly for years.

Just recently it is acting very weird - a query run with this program on the  D7 PC takes 40+ seconds (run against Sybase AND mssql, both slow).  Run using the same tool on any other PC and the query takes about 1/3 of a second...

If I copy the tool from the "bad" PC to a network drive, and run the tool from the shared drive on any other PC it works great (so it isn't the code).  I did a ghost of the  D7 PC, and applied it to a second PC (100% same hardware) - it still goes slow - so evidently not NIC or hardware related.

One thing - I installed "skype" (internet phone software) about two weeks ago.  I know skype throttles tcp/ip bandwidth usage for its own connections - maybe something bad went wrong there?  I uninstalled skype (and dug into registry to find pieces it didn't uninstall). I also ran Norton WinDoctor and cleaned up some old registry anomalies.

It still runs slow...

I need some suggestions of what to look for next - I'm stumped.  


Cheers,
EdB
0
Comment
Question by:edbored
2 Comments
 
LVL 1

Author Comment

by:edbored
ID: 11936032
Solved it.

I posted here because I suspected it was a network problem. Turns out a new SQL monitoring tool I installed turned on ODBC SQL Tracing behind the scenes. For some reason, it didn't restore the setting to stop logging when the SQL tool was closed (bad sql tool, bad!).

At any rate, every fetch from the sql engine was being logged - and THAT was taking 15 times as long as the normal SQL query...

Cheers,
EdB
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 11939751
Closed, 500 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A brief overview to explain gateways, default gateways and static routes OR NO - you CANNOT have two default gateways on the same server, PC or other Windows-based network device. In simple terms a gateway is formed when a computer such as a serv…
A common practice in small networks is making file sharing easy which works extremely well when intra-network security is not an issue. In essence, everyone, that is "Everyone", is given access to all of the shared files - often the entire C: drive …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question