Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2007-10-11 : 10:14:30
|
| If you find sp_spaceused usefull, perhaps you can explain the terminology and the arithmatic involved in making sense of the results.One Microsoft doc says something like, "database_size is biggerthan Reserved Plus Space unallocated because it includes logs."Then it says Reserved and Space Unallocated only report data andnot indexes.So you'd think size = reserved + unallocated + logs + index size.Nope. That doesn't add up.Does "Reserved" mean "allocated"Does "used" mean data and indexes and logs? Data and Indexes pages?Does "unallocated" mean "unused"BOL does not explain any of these terms.What kind of arithmatic can be used to make sense of the numbers?Forget for the time-being that SQL 2000 can return a negative number for space unallocated. That's gotta be a bug.I'm just trying to understand the terminology and what arithmatic SHOULD be valid.In various forums I find procedures and queries that cangive useful results regarding size, but I have a lot ofinstances to manage and would prefer to use what's already thereif sense can be made of it. |
|
|
|
|
|
Is sp_spaceused useful?