Use the no free space acctg option to sp_dboption, followed by the checkpoint command, to disable free-space accounting on unlogged 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 do 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.
This 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.
After you disable data segment free-space accounting, the counts may be inaccurate, even after you set no free space acctg to false. To force Adaptive Server to recalculate, issue shutdown with nowait and then restart the Adaptive Server. This may increase recovery time.
