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