dbcc stackused

Description

Database consistency checker (dbcc) checks the logical and physical consistency of a database and provides statistics, planning, and repair functionality.

Syntax

dbcc stackused

Parameters

stackused

reports the maximum amount of stack memory used since the server first started

Examples

Example 1

dbcc stackused

Usage

• The amount of stack memory used in the past is only an indication of possible needs in the future. Adaptive Server may require more stack memory than it used in the past. Run dbcc statckused periodically to find your current stack memory usage.

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Only the System Administrator can run dbcc stackused.

View this book as PDF