Monitoring free space with the last-chance threshold  Controlling how often sp_thresholdaction executes

Chapter 15: Managing Free Space with Thresholds

Crossing the threshold

As users execute transactions, the amount of free log space decreases. When the amount of free space crosses the last-chance threshold, Adaptive Server executes sp_thresholdaction:

Figure 15-2: Executing sp_thresholdaction when the last-chance threshold is reached

Graphic showing the layout of the log segment and the placement of the last-chance threshold at the beginning of the free space.



Copyright © 2005. Sybase Inc. All rights reserved. Controlling how often sp_thresholdaction executes

View this book as PDF