SQL Server 2025 – Native JSON Size Limit?

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.