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

vijay 2 gravatar image

vijay 2
236 21 21 23

(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

Thanks for reply.. My application is working in internet yes the users and servers are opposite sides but only few users raising the issue..
Jun 01, 2010 at 09:03 AM vijay 2
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

Leo gravatar image

1.6k 54 56 58

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 1084 times

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