Blog Post

SQL Server Blog
4 MIN READ

JSON parsing 10x faster than XML parsing

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 24, 2019
First published on MSDN on Nov 13, 2017 Usually, when people talk about the performance of JSON in SQL Server, they are starting with “JSON is not actually a native type, it is ...
Updated Mar 24, 2019
Version 2.0
sqlserverstorageengine
zdenek_novak's avatar
zdenek_novak
Copper Contributor
Apr 25, 2023

This should not be generalized. You are analyzing one short XML/JSON. 
Try longer variants, and, more importantly, differently "nested" variants.
You can also extract data from XML using the OPENXML method, try that, too.

We know that particuralry the structure can have many orders of magnitude effect on the speed of processing XMLs of same size. Using OPENXML can be orders of magnitude faster/slower than XML datatype functions, depending on the structure and size of XML.