Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-19 : 07:32:51
|
| Shahin writes "Could you please let me know how can I tune a SQL serverto run an application on a WAN, where the latency of channel (RTT) is about 600ms ( via satellite )?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-19 : 08:10:17
|
| There's no way to tune it. It's going to suck, a lot.DamianIta erat quando hic adveni. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-19 : 20:37:22
|
| lol Come on now Damian. It really depends on what you are trying to do over this WAN. 1. MINIMIZE the recordsets. --Do it aggressively, wherever, however, whenever possible.2. Seperate the processes on one side or the other as much as possible. --Don't transfer data repeatedly back and forth for a single process if you can avoid it.3. Monitor, monitor, and monitor some more.--Tune immediately when the monitoring finds anything.You can do this. We used to run some pretty incredible things over slow WAN's, and that was using OLD versions of Oracle and SQL Server. It takes constant tuning and monitoring though. One screwup at any given point can mess up the whole applications quickly. Also, be aware that with satellite, sometimes even the best tuned system is going to suck like Damian said. Monitor the traffic, routes, and response times to make sure it's clean and nothing changes without you knowing. I would start building a good relationship with someone at the provider if you haven't already done so.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-05-19 : 23:58:15
|
| Is is a Web app (n-tier) or a client server App?If it is a web app, are the web servers on the same LAN as the SQL Server, or are they on the other end of the WAN link?CODO ERGO SUM |
|
|
|
|
|
|
|
|
Tunning SQL server for VPN via satellite