question

Gergav38 avatar image
Gergav38 asked

Whats using Space in My Database ?

Hi , I have a DB which is reporting the following. EXEC sp_spaceused @updateusage = N'TRUE'; database_name database_size unallocated space GL***_*** 171804.38 MB 30246.53 MB reserved data index_size unused 140346208 KB 114488712 KB 25590816 KB 266680 KB The Primary File where I have the Tables is 143670656 KB. The Indexes are in their own FG's.. What I can't understand is when I run sp_spaceused on all tables it adds up to about 80gb. taking the unused space into AC I'm still 'missing' 31 gb . If rebuilt all the Indexes. I've ran dbcc updateusage Is there anything I'm missing. It's driving me nuts !!!
database size
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Gergav38 avatar image
Gergav38 answered
I'll answer it myself , sp_spaceused 'sys.sysxmitqueue' name rows reserved data index_size unused sysxmitqueue 282 72141880 KB 72141792 KB 32 KB 56 KB
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.