Error 17872

Severity

0

Message text

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

Explanation

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

Action

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