Adding a Threshold to a Segment

Create a threshold to monitor space on a database segment.

1. In the left pane of the Administration Console, expand ASE Servers > Space Management > Segments.
2. Click the Name field of the segment, then click the drop-down arrow and select Properties.
3. Click Thresholds. Any existing threshold-related stored procedures for this segment appear in the table, listed by procedure name, owner, and the amount of free space, in megabytes.
4. Click Add to view the Add New Threshold wizard page.
5. Choose a stored procedure, and specify its free-space threshold in pages, kilobytes, megabytes (the default), or gigabytes.
6. Click Apply after each new stored procedure you add, and OK when you are finished.