Applies to master database only. sysresourcelimits contains a row for each resource limit defined by the SAP ASE server. Resource limits specify the maximum amount of server resources that can be used by an SAP ASE login or an application to execute a query, query batch, or transaction.
The columns for sysresourcelimits are:
Name |
Datatype |
Description |
---|---|---|
name |
varchar(30) null |
Login name |
appname |
varchar(30) null |
Application name |
rangeid |
smallint |
id column from systimeranges |
limitid |
smallint |
id column from spt_limit_types |
enforced |
tinyint |
Subset of the enforced column
from spt_limit_types:
|
action |
tinyint |
Action to take on a violation:
|
limitvalue |
int |
Value of limit |
scope |
tinyint |
Scope of user limit (a bitmap indicating
one or more of the following):
|
spare |
tinyint |
Reserved |
Clustered index on name, appname