Adaptive Server Enterprise provides resource limits to help System Administrators prevent queries and transactions from monopolizing server resources. Resource limits, however, are not fully specified until they are bound to a time range.
A resource limit is a set of parameters specified by a System Administrator to prevent an individual login or application from:
Exceeding a given estimated or actual I/O costs.
Returning excessive rows on a per query basis.
Exceeding a given elapsed time on a query batch or transaction basis.
Utilizing excessive tempdb space per session.
In Adaptive Server Enterprise version 12.5.3, when the System Administrator modifies a resource limit, all users logged in the session see the change, including the System Administrator.
See “sp_help_resource_limit” for more information.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
