Limiting Access to Server Resources

System administration includes using resource limits to restrict the I/O cost, row count, processing time, or tempdb space that an individual login or application can use during critical times, and creating named time ranges to specify contiguous blocks of time for resource limits.

• Resource Limits
  A resource limit is a set of parameters specified by a system administrator, that prevents queries and transactions from individual logins or applications from monopolizing server resources.
• Plan Resource Limits
  There are a number of issues you should consider when planning resource limits.
• Enable Resource Limits
  Use the allow resource limits configuration parameter to enable resource limits.
• Define Time Ranges
  A time range is a contiguous block of time across one or more contiguous days of the week.
• Identify Users and Limits
  For each resource limit, specify the object to which the limit applies, for example, all applications used by a particular login, all logins that use a particular application, or a specific application used by a particular login.
• Understanding Limit Types
  Resource limits allow you to limit resource usage in different ways, including by I/O cost, elapsed time, row count, tempdb space usage, and idle time.
• Creating a Resource Limit
  Create a new resource limit using sp_add_resource_limit.
• Getting Information on Existing Limits
  Use sp_help_resource_limit to get information about existing resource limits.
• Modifying Resource Limits
  Use sp_modify_resource_limit to specify a new limit value or a new action to take when the limit is exceeded or both. You cannot change the login or application to which a limit applies or specify a new time range, limit type, enforcement time, or scope.
• Dropping Resource Limits
  Use sp_drop_resource_limit to drop a resource limit from an SAP ASE.
• Resource Limit Precedence
  SAP ASE provides precedence rules for time ranges and resource limits.