x

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 !!!

more ▼

asked Jul 13 at 11:00 AM in Default

avatar image

Gergav38
82 7 7 11

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Jul 13 at 12:34 PM

avatar image

Gergav38
82 7 7 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x9

asked: Jul 13 at 11:00 AM

Seen: 17 times

Last Updated: Jul 13 at 12:34 PM

Copyright 2017 Redgate Software. Privacy Policy