Solved

DB Query Response Time and Lan Utilization

Posted on 2008-10-24
3
380 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Is your computer hacked? learn how to detect and delete malware in your PC
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

786 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