Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC Based SQL query appears to be "throttled"

Posted on 2004-08-28
2
Medium Priority
?
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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…
This is the first one of a series of articles I’ll be writing to address technical issues that are always referred to as network problems. The network boundaries have changed, therefore having an understanding of how each piece in the network  puzzl…
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

636 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