Adaptive Server Configuration

Document general information about the ASE configuration.

General Configuration

Home directory:  

Components, release and fix levels:  

 

 

 

 

 

Locations/names of scripts to rebuild database environment:  

 

 

 

 

 

sp_configure configuration values:  

 

 

 

buildmaster configuration values:  

 

 

 

Run dbcc memusage on ASE during an off-peak time or in single-user mode.

Usage

MB

2K Pages

Bytes

Configured memory

 

Code size

 

Kernel structures

 

Server structures

 

Page cache

 

Proc buffers

 

Proc headers

 

Number of page buffers

 

Number of proc buffers