sql server slow responce.

[kueyiar]

Hi, we've just connected a second site to our hq offices. We have a 128mb dedicated link from this second site to our hq. We are running an vfp/sql client/server application. The thing is, it takes about 1min and a half to load up the application when at hq office takes about 3-5seconds, queries take almost twice as long on our second site. Tried upgrading the link to 256mb and problem remains. Database updates take about 1min45sec on second site where as on hq it takes about 5 seconds. Any sugestions ? I really need the help, any advice or suggestions ?

 

[donutman]

Welcome to broadband access, not.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[darrellblackhawk]

Sounds like you need to rethink the architecture of your
application or get T1 lines connected between offices.

You can get 2 T1's for as low as $400(approx.)x2= $800 per month. (Or even fractional T1's - maybe even cable)

Redesigning the apps I assume would cost a lot more.

Anyway, your stuck until you make a move in either direction.


Darrell

 

[vongrunt]

Hm... kueyiar was talking about 128mb and 256mb. Typo (m <==> k)?

Before taking any "thick wire" approach, determine why it happens.

If app redesign is not an option, also consider using terminal/remote services a la Citrix.

------
Math problems? Call 0800-[(10x)(13i)^2]-[sin(xy)/2.362x]

 

[donutman]

True, it could be something else, but 128kb is a slow connection so it's very likely the culprit. I have leased T1's between locations and performance is hurt but bearable at the remote locations. (I wouldn't feel that way if I spent most of my time there!)
The solution I used prior to having a T1 was ISDN with remote servers running replication. Citrix is an interesting approach. VNC is free, but I never thought about having 2 PCs for every user...it may actually be cost effective!
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[darrellblackhawk]

I was thinking about my post and I see others have posted
that which I would append - terminal services.

Replication; as DonutMan suggests, might help also, but if
the data's real-time, the clients will invariably
experience slow response when the local server has to go
to the hq for updates.


Darrell

 

[donutman]

That's done in the background if you choose the appropriate replication method for your situation. Real-time is fudged. You should definitely give all three methods consideration: T1, Citrix (terminal services) and replication.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]