How To Solve This??

Hi Everyone,

we are using the sql 2005 for my application. One of my client reported like when ever he typed the URL like http:google.in(my application url)the page is opening very fast when he tried to login its taking more time.so he is asking to resolve this.

So please suggest what was the actual cause?What are all the things i need to check?

Thanks in advance..

more ▼

asked Jun 01, 2010 at 08:47 AM in Default

avatar image

vijay 2
236 21 21 26

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I'm confused. You mean that your client is able to browse the internet but is having trouble connecting to your app? Is your app local to the client or is it also on the internet? If your app is on the internet and the client is browsing to it, then there are four factors that will affect them 1) Their connection to the internet 2) General internet performance 3) Distance to your site 4) Your site's connection to the internet.

You can't do anything about 1 or 2 and it sounds like they're not the issue. As to 3 and the general issue of latency, how far away is the client from your machine? Are you on opposite sides of the planet? That will cause rather severe performance issues. The way around it is to put up mirror sites in various locations in order to reduce latency, or, at least, make your app as non-chatty (reduce round trips) as possible. To address 4, you need to look to your machines. Are you having issues? What's the turnaround time locally? Are there other problems? You haven't provided enough information for me to make a guess on this one.

more ▼

answered Jun 01, 2010 at 08:57 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

Network latency is just a huge issue. There's no magic bullet. Everyone compares to google, but google has machines all around the planet so that no one has to travel far to get the signal. Just remember, 18 inches is about how far an electron travels in a millisecond. That's a physical limitation on speed. You have to reduce volume, reduce signal or reduce distance, or all three.

Jun 01, 2010 at 10:46 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left


That is something to do with your database connection when users try to log in. You can use sql profiler to trace the store procedure to check which part taking too long to process.


more ▼

answered Jun 01, 2010 at 08:52 AM

avatar image

1.6k 55 59 62

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 01, 2010 at 08:47 AM

Seen: 1282 times

Last Updated: Jun 01, 2010 at 09:24 AM

Copyright 2018 Redgate Software. Privacy Policy