Solved

ODBC Based SQL query appears to be "throttled"

Posted on 2004-08-28
2
261 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

Gigs: Get Your Project Delivered by an Expert

Select from 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

Suggested Solutions

Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

776 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