Using thresholds to prevent running out of log space

If your database has limited log space, and you occasionally hit the last-chance threshold, install a second threshold that provides ample time to perform a transaction log dump. Running out of log space has severe performance impacts. Users cannot execute any data modification commands until log space has been freed.