Forum Discussion

tuspatil's avatar
tuspatil
Copper Contributor
Oct 09, 2025

SQL Server 2025 – Native JSON Size Limit?

Hi Guys,


I am exploring SQL Server 2025 to store JSON documents using the native JSON data type.
I have gone through several Microsoft SQL technical documents but couldn’t find the maximum size of the native JSON data type. I believe it hasn’t been officially published yet.
Does anyone have any insights?

 

Thanks,

Tushar

json
json native
MAx SIZE
Sql Server 2025

1 Reply

  • carlwalk's avatar
    carlwalk
    Copper Contributor
    Nov 08, 2025

    From what I’ve seen so far, Microsoft hasn’t officially shared any documentation around the maximum size for the new native JSON data type in SQL Server 2025. In real-world use, it’s better to keep JSON documents smaller. Performance tends to drop off as the size grows, especially when you start querying or indexing JSON fields. If you’re dealing with very large documents, splitting them across multiple rows or tables or storing them externally (e.g., in Blob storage) might be a better approach.

Resources