We are doing PoC for migration of our data from SQL Server to MongoDB. Our workload is performing far better on MongoDB as compared to SQL server. But before the final migration, we have some specific questions that need to be answered. The main thrust of the questions is centred around the idea as to what makes MongoDB perform better than SQL Server.
- Data Storage - So we know MongoDB stores data as BSON and SQL server stores them as 8Kb pages. So does storing the data in form of BSON files makes it faster compared to SQL Server.
- Replication and Sharding - MongoDB provides support for repplication and sharding. But so does SQL Server. Is there any way that replication and sharding support in MongoDB outweighs that of SQL Server.
- Caching - Is the way MongoDB caches working set data more effective that the SQL server caching.
also, it would be great if links to any supporting documentation could be provided that will help us explain the superior performance of MongoDB over SQL Server.