Solved

DB Query Response Time and Lan Utilization

Posted on 2008-10-24
3
384 Views
Last Modified: 2012-05-05
Dear experts:

Here is a situation:

DB query response time 2-6 seconds.
But Lan utilization is very steady.

What might explain the discrepancy?

Thanks!
0
Comment
Question by:duta
[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
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 22800368
That is a very broad question.

First off if you run the same query on the server what is response time?

What DB are you using?

What authentication are you using?

Is this an established connection or one just created?

Is it all clients or just some of them?

When you say LAN is it one build building or spread across a campus?

Is the LAN one giant one or is it virtualized (sub-netted/VLANs)?

Is it only one VLAN that is having the issue?

"Lan utilization is very steady." --> Whats the steady throughput?
0
 

Author Comment

by:duta
ID: 22800412
I am helping someone who is doing her homework using IT Guru.
She is running a simulation. The simulation showed two graphs:
One graph showed a wide fluctuation in DB Query response time from 2 seconds to 6 seconds.

Another simulation graph showing LAN utlization  shows  a steady (almost horizontal line).
The question is:

In the first run, you see DB query response time varying from 2 secs to 6 secs. But when you look at the LAN Utilization, it is steady.  What could account for the variation in the DB query response time?

I am a novice, and am not in a position to help someone.   It is hard to tell that I don't know.

Thanks!
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22809025
That narrows it down some, but it can be from the caching of the on the server. I would say that it is a server utilization question.
0

Featured Post

Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

724 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