?
Solved

DB Query Response Time and Lan Utilization

Posted on 2008-10-24
3
Medium Priority
?
385 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 2000 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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

764 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