October 20, 2005 at 10:31 am
We have around 10 SQL Servers to hold our data. Each holds its data that is replicated overnight, thus causing redundancy and alot maintenance. The reason we do this is because of client load. We had to use multiple servers to be able to handle the load for immediate query responses across the internet. I am trying to come up with suggestions on how to reduce this redundancy but am at a loss. Does anyone have any suggestions on improvements for this setup?
TIA
October 21, 2005 at 7:38 am
Can you elaborate on the setup a bit? Are the servers distributed around the country? Unless you're working for Ebay or Amazon, I'm missing something here. In my experience (admittedly NOT with the above mentioned size companies) you can do "immediate query responses across the internet" IF the data is laid out logically, properly indexed, and well written stored procedures are used. For our company the limiting factor is usually internet bandwidth. So please elaborate, we'll all learn something here.
P.S. Assuming you do have such a large project that no multi-processor box on earth can handle it, replication is certainly the correct answer. But what is the maintenance question? Once set up, we've found that replication works well by itself.
Please understand that I'm not bashing your question. I just don't fully understand what you're asking and why.
Student of SQL and Golf, Master of Neither
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply