Use sp_helpthreshold to get information about all thresholds in a database. Use sp_helpthreshold segment_name to get information about the thresholds on a particular 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 (1 row affected, return status = 0)
