Managing Free Space with Thresholds

When you create or alter a database, you allocate a finite amount of space for its data and log segments. As you create objects and insert data, the amount of free space in the database decreases.

Related tasks
Placing a Transaction Log on a Separate Device
Querying the syslogshold Table