Adaptive Server provides resource limits to help System Administrators prevent queries and transactions from monopolizing server resources. A resource limit is a set of parameters specified by a System Administrator to prevent an individual login or application from:
Exceeding estimated or actual I/O costs, as determined by the optimizer
Returning more than a set number of rows
Exceeding a given elapsed time
The set of parameters for a resource limit includes the time of day to enforce the limit and the type of action to take. For example, you can prevent huge reports from running during critical times of the day or kill a session whose query produces unwanted Cartesian products.
To specify times of the day or week, you can create named time ranges. A time range is a contiguous block of time within a single day across one or more contiguous days of the week. It is defined by its starting and ending periods. Contiguous days of the week are allowed to wrap around the end of one week to the beginning of the next.
Adaptive Server includes one predefined time range, the “at all times” range, which covers the period of midnight to midnight, Monday through Sunday. You can create, modify, and drop additional time ranges as necessary for resource limits.
For more information on resource limits, see Chapter 12, “Limiting Access to Server Resources,” in the System Administration Guide.
