sa_db_properties system procedure

Function

Reports database property information.

Syntax

sa_db_properties ( [ database-id ] )

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

Returns the database ID number and the Number, PropNum, PropName, PropDescription, and Value, for each property returned by the sa_db_info system procedure.

Example

sa_db_properties

0,10,'CacheHits','Cache Hits','4660'
0,11,'CacheReadIndInt','Cache index interior reads','334'
0,12,'CacheReadIndLeaf','Cache index leaf reads','1117'
0,15,'CacheRead','Cache reads','4887'
0,19,'CacheReadTable','Cache table reads','2025'
0,20,'CacheReadWorkTable','Cache work table reads','4'
0,22,'ChkptFlush','Checkpoint flushed pages','64'/
0,23,'ChkptPage','Checkpoint log page images saved','64'
0,24,'CheckpointUrgency','Checkpoint Urgency','7'
0,25,'Chkpt','Checkpoints','2'
0,26,'CheckpointLogBitmapSize','Checkpoint log bitmap size','0'
'0,27,'CheckpointLogBitmapPagesWritten','Checkpoint log writes to bitmap','0'
0,28,'CheckpointLogCommitToDisk','Checkpoint log commit to disk','8
0,29,'CheckpointLogPageInUse','Checkpoint log pages in use','62'
0,30,'CheckpointLogPagesRelocated','Checkpoint log pages relocated','0'
0,31,'CheckpointLogSavePreimage','Checkpoint log save preimage','64