Solved

DB Query Response Time and Lan Utilization

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server - Check Constraint or NOT NULL? 11 67
forward schedule of change 1 16
Powershell script 13 57
DBF to ... Converter 5 32
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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 tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now