Comparison of SQL Server with MongoDB
SQL and NoSQL are different in many ways but the gist of it is that SQL is better at relational and NoSQL is better at non-relational. Each technology is suited for different purposes.

There are plenty of existing benchmarks and comparisons between the two such as here, here and here. Be wary of the bias in comparison articles and note that when someone says NoSQL is faster it could mean with less reliability.

To benchmark SQL queries you can look up the following:


SET STATISTICS TIME ON


Or use something similar to this:

DECLARE @DateTimeStamp DATETIME
SET @DateTimeStamp = current_timestamp
... --do some stuff to measure here
PRINT CAST(DATEDIFF(ms, @DateTimeStamp, current_timestamp) AS VARCHAR) + 'ms'


To benchmark MongoDB queries you can look up the following:


.explain("executionStats")
mongodb executionTimeMillis




Here are some comparisons between the two:

SQL


More expensive initial cost
Relational
Better data integrity with transactions ( more overhead )
More common so more developers have experience with it
More proven security
Paid tools for metrics and monitoring such as Solar Winds and Idera
There are likely free tools but I am not aware of them


NoSQL ( MongoDB )


Less expensive initial cost
Non-relational
No transactions ( less overhead )
Asynchronous INSERT and UPDATE
Depending on Write Concern Values it could be faster with less reliability or slower with more reliability
Possibly more scalable
Less proven security
Paid tools for MongoDB server metrics and monitoring such as Server Density.