patternsqlMinor
Horizontally scaling SQL Server, distributing the database with sharding
Viewed 0 times
thedistributingsqlwithhorizontallyscalingdatabaseserversharding
Problem
I wanted to know if there is any way to distribute a SQL Server (I'm using 2012 version) database accross multiple nodes. I'm trying to compare READ queries performance between SQL Server and MongoDB. The distribution is all set with MongoDB with different shards using virtual machines and I wanted to make a similar setting for SQL Server, but I'm facing lots of trouble.
Is there any material on how to do that? Is that as tough process as it seems?
Is there any material on how to do that? Is that as tough process as it seems?
Solution
Is there material on how?
Yes. You can read about it at https://msdn.microsoft.com/en-us/library/dn589797.aspx
Is the process as tough as it seems?
Sort of. It is time consuming in that it requires careful planning in advance on how you want to structure the data, but if you're doing something with a massive database, I've personally been very pleased with the performance enhancement.
Yes. You can read about it at https://msdn.microsoft.com/en-us/library/dn589797.aspx
Is the process as tough as it seems?
Sort of. It is time consuming in that it requires careful planning in advance on how you want to structure the data, but if you're doing something with a massive database, I've personally been very pleased with the performance enhancement.
Context
StackExchange Database Administrators Q#142421, answer score: 3
Revisions (0)
No revisions yet.