For some reason my MSDB database has grown huge in just a few days.
June 1 backup is 3.5 gig
June 2 backup is 6.5 gig
June 3 backup is 13 gig
June 4 backup is 25.5 gig !!!
By running the query below, I see that no tables have a huge amount of records, but the table "sysmail_mailitems" has reserved_page_count = 3903216 and is now about 30 Gig !! But there are only 6,000 rows.
What is going on here ? I am not familiar with this table and am off to read up on it now.
SELECT o.name, ddps.row_count , reserved_page_count as 'Resrv Page', (used_page_count * 8)/1024 as Mbytes, *
FROM sys.indexes AS i
INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID
INNER JOIN sys.dm_db_partition_stats AS ddps ON i.OBJECT_ID = ddps.OBJECT_ID
AND i.index_id = ddps.index_id
ORDER BY ddps.row_count desc