space available - 12-05-2005 , 11:16 AM
In Enterprise Manager, I view my databases in the Taskpad view. In one of
my dbs, Under the Database section in the General tab, the db size is
reported as 175,000 MB, with space available of 63,619 mb. That would
indicate that I have 111 MB used. However, in the Space allocated section
at the bottom, I can see that my data is consuming 65,995 MB and my log is
presently consuming 2,825 MB. This does not equal 111 MB. Also, my backups
are around 66 GB - not 111 GB.
What gives? And how can I get these to be correct?
Re: space available - 12-05-2005 , 12:52 PM
Reports and corrects inaccuracies in the sysindexes table, which may
result in incorrect space usage reports by the sp_spaceused system
try running this to update your server stats.
Re: space available - 12-05-2005 , 06:27 PM
Is it right to assume that "DBCC UPDATEUSAGE" takes a long time to run,
especially if its a large DB. I have a SP that monitors space used, our DB
ranges from a min or 200 GB to 1 TB and the SP runs every day. So in the SP,
I do not updateusage, should I enable it?
Re: space available - 12-06-2005 , 10:50 AM
i'm not sure i quite understand your question. you have an sp that
monitors diskspace and it ranges from 200GB to 1TB why would it vary
so much. is that your log file that grows i do not completely
Re: space available - 12-06-2005 , 02:09 PM
Well the datafile size can range from 200 GB to 1 TB based on our customers.
It depends so much based on the size of our customers. So the bigger the
customer more the data. We not only monitor Datafile disk, but also log
disk, archive disks, etc.