April 2, 2007 at 12:11 pm
Does anyone have pointers to white papers or books, articles, posts, anything, on best practices & methods around maintaining two servers, say one in NYC and another in Melbourne or Sydney, in order to cut down the latency for the end users to access data? Special emphasis on SQL Server 2005 technologies would be appreciated.
I've been looking, but I just can't find anything. Thanks for your time.
Grant
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2007 at 8:31 am
I don't know of anything that will help out here, other than hiring an expert who can guide/assist you in this endeavour.
Best of luck with your project! Sounds like fun. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
April 3, 2007 at 10:22 am
have you thought about merge replication. That should keep both datasets up to date yet, you can specify which SQL server the end user connects to.
Marvin
Marvin Dillard
Senior Consultant
Claraview Inc
April 3, 2007 at 11:04 am
Thank you. Yes, that is on the list as a possibility. I'm just trying to explore the space and I'm not finding much in the way of documented approaches.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply