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.

An application is a client program that is running on top of SAP ASE, accessed through a particular login. To run an application on SAP ASE, specify its name through the CS_APPNAME connection property using cs_config (an Open Client™ Client-Library™ application) or the DBSETLAPP function in Open Client DB-Library™. To list named applications running on your server, select the program_name column from the master..sysprocesses table.

For more information about the CS_APPNAME connection property, see the Open Client Client-Library/C Reference Manual. For more information on the DBSETLAPP function, see the Open Client DB-Library/C Reference Manual.

• Identifying Heavy-Usage Users
  Before you implement resource limits, run sp_reportstats. The output from this procedure can help you identify users with heavy system usage.
• Identifying Heavy-Usage Applications
  To identify the applications running on your system and the users who are running them, query the sysprocesses system table in the master database.
• Choosing a Limit Type
  After you determine the users and applications to limit, chose the resource limit type.
• Determining Time of Enforcement
  Time of enforcement is the phase of query processing during which SAP ASE applies a given resource limit.
• Determining the Scope of Resource Limits
  The scope parameter (for example, sp_add_resource_limit scope or sp_help_resource_limit scope) specifies the duration of a limit in Transact-SQL statements.