Use the no free space acctg option to sp_dboption, followed by the checkpoint command, to disable free-space accounting on non-log segments. You cannot disable free-space accounting on the log segment.
When you disable free-space accounting, only the thresholds on your log segment monitor space usage; threshold procedures on your data segments will not execute when these holds are crossed. Disabling free-space accounting speeds recovery time because free-space counts are not recomputed during recovery for any segment except the log segment.
The following example turns off free-space accounting for the production database:
sp_dboption production, "no free space acctg", true
WARNING! If you disable free-space accounting, system procedures cannot provide accurate information about space allocation.
