I wanna monitor the size of each table in my database. After doing so, I was wondering why the sum of the data of each table does not correnspond to the data size of the whole database I get after calling sp_spaceused.
Here are my results:
ExampleDatabase: 46 589 544 KB (data)
Sum(data) of each table: 18 564 680 KB (data)
The only objects I was ignoring while saving each tables size (data) were the system-tables and some tables, whose size is not worth talking about.
Because I can't see the error in my "catch table size procedure", I'm wondering if it's the sp_spaceused.data column, which maybe contains more than the sum of each table data?