Chapter 1: System Tables

sysresourcelimits

master database only

Description

sysresourcelimits contains a row for each resource limit defined by Adaptive Server. Resource limits specify the maximum amount of server resources that can be used by an Adaptive Server login or an application to execute a query, query batch, or transaction.

Columns

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: 1 = prior to execution 2 = during execution 3 = both
action	tinyint	Action to take on a violation: 1 = issue warning 2 = abort query batch 3 = abort transaction 4 = kill session
limitvalue	int	Value of limit
scope	tinyint	Scope of user limit (a bitmap indicating one or more of the following): 1 = query 2 = query batch 4 = transaction
spare	tinyint	Reserved

Indexes

Clustered index on name, appname

View this book as PDF