Horizontally scaling SQL Server, distributing the database with sharding 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 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.