Record the following Sybase information:
Adaptive Servers and their SYBASE home directories
Components and release levels (including EBFs)
Names and location of scripts to rebuild database environment
All server configuration values; these can be listed by sp_configure. or found in the .cfg file.
Server runtime memory map: Run dbcc memusage during non-peak time or in single user mode. This command tells you how memory is configured within ASE. See the Performance and Tuning Guide for more information about ways to capture server memory statistics. You can record the output of dbcc memusage in a table like this one:
Mb |
2K Blocks |
Bytes |
|
|---|---|---|---|
Configured Memory |
10.0000 |
5120 |
10485760 |
Code size: |
2.7075 |
1387 |
2839060 |
Kernel Structures: |
1.5924 |
816 |
1669755 |
Server Structures: |
1.8529 |
949 |
1942928 |
Page Cache: |
3.0496 |
1562 |
3197756 |
Proc Buffers: |
0.0270 |
14 |
28348 |
Proc Headers: |
0.6191 |
317 |
649216 |
Number of page buffers: |
1489 |
||
Number of proc buffers: |
372 |
