February 23, 2007 at 11:32 am
What is the best way to handle load balancing with Sql Server 2005? I have been reading about the way you can spread the read-write operations across multiple disks using the new table level partitioning, but there is still a bottle neck since all access is passed through a single sql server instance.
Then there is the mirroring which provides for multiple sql server instances over a single database, but the replication delay and the limits on using identity fields is a bummer.
What we are looking at is possibly multiple servers country wide that would be able to handle the network traffic of 1000's of concurrent users. I know Barnes and Noble has to have the same issue in a grander scale. Are there any study guides on this or information for how someone else rose to this challenge?
February 24, 2007 at 12:58 am
Peer to Peer transactional replication...
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1133488,00.html
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply