Creating Threshold Procedures

SAP does not supply threshold procedures; create them yourself to ensure that they are tailored to your site’s needs.

Suggested actions for a threshold procedure include writing to the server’s error log and dumping the transaction log to increase the amount of log space. You can also execute remote procedure calls to an Open Server or to XP Server.

For example, if you include the following command in sp_thresholdaction, it executes a procedure named mail_me on an Open Server:
exec openserv...mail_me @dbname, @segment

See the Transact-SQL Users Guide.

This section provides some guidelines for writing threshold procedures, as well as two sample procedures.

Related tasks
Creating a Free-Space Threshold for the Log Segment
Creating Additional Thresholds on Data and Log Segments