Sunday, March 25, 2012

DBCC ShowFileStatus v. SP_Spaceused

In trying to determine how much space is begin used by a database and how
much space is free, DBCC ShowFileStatus and SP_Spaceused give simillar, but
different results. Which is more accurate?
DBCC is accurate. Read the source for sp_spaceused and you will see that it picks up the info from
sysindexes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"vtcs212" <vtcs212@.discussions.microsoft.com> wrote in message
news:DC3D36A0-E5A6-43AE-94F0-ECE6AC081407@.microsoft.com...
> In trying to determine how much space is begin used by a database and how
> much space is free, DBCC ShowFileStatus and SP_Spaceused give simillar, but
> different results. Which is more accurate?
sql

No comments:

Post a Comment