Solved

SQL server in Germany - the forward facing server in the UK - Any issues to be aware of?

Posted on 2007-04-05
6
377 Views
Last Modified: 2010-04-20
Hi Experts,

I currently have 2 x dedicated servers both in the same datacentre.

Would having a SQL server in Germany and the forward facing server in the UK have any adverse speed issues or anything else I woudl need to be concerned about.

I need to have the forward facing one in the UK mainly for the customer service that my host offers and to help with UK search engine results.

Look froward to your comments.
0
Comment
Question by:alexealden
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 51

Expert Comment

by:ahoffmann
ID: 18862646
hmm, that sounds impossible according your description:
  1. servers both in the same datacenter
  2. SQL server in Germany
  3. server in UK

You either need to make Germany=UK or explain better what you mean ;-)
0
 

Author Comment

by:alexealden
ID: 18873037
Currently I have 2 servers in the same data centre in the UK

I am thinking of re-locating the sql server to Germany due to cost savings - could this prove to be less reliable than having both servers in a UK datacentre or should it make little difference?

0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 18873085
should be secure if you use an encrypted conection (SSL or whatever) *and* the web application has no vulnerabilities.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:alexealden
ID: 18874652
OK Thanks - I am more worried about perrformance mainly ... presumably it should be pretty much the same?
0
 
LVL 51

Accepted Solution

by:
ahoffmann earned 500 total points
ID: 18875738
well, performance should not be a problem as long as you do not pull or push huge data for each request between the  servers
Performance also depends on your network bandwidth, which will be the bottleneck.
0
 

Author Comment

by:alexealden
ID: 18923180
Thanks for your advice - thats just what I needed.
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question