Hi EveryBody, When examining the

[jaballah]

Hi EveryBody,

When examining the output from sp_spaceused for a user database, is it critical that the value under "unused" field falls below small percentage (let's say 10%) from the "reserved" value? even if the "database_size" is much biger than the "reserved" value?

For example :

database_size = 3429.0 MB
reserved = 116532 KB
data = 94098 KB
index_size = 16590 KB
unused = 5844 KB


Does the "reserved" space mean the growth limit for existing objects (tables). e.i. the remaining space from "database_size" beyond the "reserved" is only available for new objects?!
If not, then what happens when the "unused" reaches 0% ?!



Thanks forwardly
Ati