question

vijay 2 avatar image
vijay 2 asked

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

sql-server-2005performanceperformance-tuningnetwork
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image
Leo answered

Hi,

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.

Thanks.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
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.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.