Error 17872



Message text

This threshold is too close to one or more existing thresholds. Thresholds must be no closer than 128 pages to each other.


This error occurs when an attempt is made to add or modify thresholds (using sp_addthreshold or sp_modifythreshold), that are too close together.


Thresholds for a database cannot be closer than:

(<size_of_threshold> + (2 * @@thresh_hysterisis))

Ensure that the free space allocation allows enough pages. Rerun the command with the appropriate value for free space.

Additional information

Refer to the chapter “Managing Free Space with Thresholds” in the System Administration Guide: Volume 2 for information about threshold size and hysteresis value.

Versions in which this error is raised

All versions