Determining Threshold Placement

Each new threshold must be at least twice the @@thresh_hysteresis value from the next closest threshold.

For example:


Graphic of a bar graph that shows the placement of the last chance threshold being twice the @@thresh_hysteresis value.

To see the hysteresis value for a database, issue:

select @@thresh_hysteresis 
In this example, a segment has a threshold set at 100 pages, and the hysteresis value for the database is 64 pages. The next threshold must be at least 100 + (2 * 64), or 228 pages:
select @@thresh_hysteresis
----------- 
        64
sp_addthreshold mydb, user_log_dev, 228, 
sp_thresholdaction