DB Size Reports Inaccurate 1

[Ovatvvon]

Hi All

We have a database on our SQL 2005 server that, when running a report for DB Current Size on Disk, displays inaccurate information.

The database file size (MDF) is 91 GB in size. However, in the report, it says it is 815 GB. (Actually, it says it is 815,546.51 MB). Another wierd thing is it says the Tran Log file is "-696,812.63 MB". (The LDF file is about 30 GB on disk). How could that be a negative number? And why would these sizes be so off?

I ran a DBCC CHECKDB, but it came back without problems.

I also ran a sp_spaceused against one particular table in the database (one of the largest ones), and its information doesn't seem right either...

[b]name[/b]
CALLS
[b]rows[/b]
93,098,559
[b]reserved[/b]
819,100,104 KB
[b]data[/b]
38,978,880 KB
[b]index_size[/b]
32,397,832 KB
[b]unused[/b]
747,723,392 KB

Does anyone know what might be causing these numbers to get skewed so much?



-Ovatvvon :-Q

 

[mrdenny]

You need to update the space information.

exec sp_spaceused @updateusage = 'updateusage'
go

It will take a while to run on a database that large.

The SQL Server space info can get out of whack on large systems every once and a while.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Ovatvvon]

Is that something that could bog down the system? Normally we have the red-tape to worry about on production boxes, and have to get change records prior to immplementing. If it is a heavy task, I'd rather hold of doing that, as the need for it isn't that bad.

-Ovatvvon :-Q

 

[mrdenny]

Not really. It does add extra load to the system though.

When your not sure, fill out the paperwork.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Ovatvvon]

This worked great!

Thanks Denny!


-Ovatvvon :-Q

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com