The data base total data files sizes are 35GB. The following are the top 10 tables with sizes in KB's. But tables sizes are around 1GB but database size 35GB why?
There could be a number of reasons for the database to be taking the size it does on disk.
To see where the space is you can use these queries when connected to the database you are interested in
read how they work and what information they provide at the links shown
answered Jul 03 '12 at 07:43 AM
I would suggest that you are storing a lot of BLOB data and your method of calculating row sizes doesn't take that into account.Does the dB store .doc, .xml, .mp3, .xls, etc.?
answered Jul 04 '12 at 12:21 PM