You can use the following SQL query to examine the size of the JsonData column for each row. This query returns the top 100 rows with the largest JSON data entries, showing the size in bytes.

The DATALENGTH function returns the size of the JsonData column in bytes. This helps determine whether the table's size is driven by a few large entries or a large volume of smaller ones.

SELECT TOP (100) [ClientId]

   ,[ScriptName]

   ,[ScriptRunUTCTimeStamp]

   ,[DataReceivedUTCTimeStamp]

   ,[DaysToRetain]

   ,[JsonFileName]

   ,[JsonData]

 ,FORMAT(DATALENGTH([JsonData]),'### ### ### ##0')

 FROM [SnowInventory].[inv].[ClientStorageData]

 order by DATALENGTH([JsonData]) desc