Displaying Information About Existing Thresholds

Use sp_helpthreshold to get information about all thresholds in a database. You can include a segment name with the stored procedure to get information about the thresholds on the specified segment.

The following example displays information about the thresholds on the database’s default segment. Since “default” is a reserved word, you must enclose it in quotation marks. The output of sp_helpthreshold shows that there is one threshold on this segment set at 200 pages. The 0 in the “last chance” column indicates that this is a free-space threshold instead of a last-chance threshold:
sp_helpthreshold "default"
segment name   free pages   last chance?   threshold procedure
------------   ----------   ------------   -------------------
default        200                     0   space_dataseg