DB Query Response Time and Lan Utilization

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!
dutaAsked:
Who is Participating?
 
Jim P.Connect With a Mentor Commented:
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
 
dutaAuthor Commented:
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
 
Jim P.Commented:
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
All Courses

From novice to tech pro — start learning today.