Symptom
The "Number of proc buffers allocated" message mentioned in the "System Administration Guide" no longer appears in the errorlogs of newer versions of Adaptive Server Enterprise.
ASE 15.7 ESD #2 System Administration Guide Volume 2 says:
"------------------------------------
Adaptive Server Enterprise 15.7 ESD #2
- System Administration Guide: Volume 2
- Configuring Memory
- Configuration parameters that control Adaptive Server memory
- Data and procedure caches
------------------------------------
Chapter 3: Configuring Memory
Monitoring cache space
........
Procedure cache messages
These error log messages provide information about the procedure cache:
server: Number of proc buffers allocated: 556
server: Number of blocks left for proc headers: 629
------------------------------------"
But in ASE 12.5.x and later, the message "Number of proc buffers allocated: xxxx" no longer appears.
Only the "Number of blocks left for proc headers: xxxxx" message remains.
For examples of the messages that appear in the errorlog of various ASE versions, see below.
-- ASE 12.0.0.8 --
00:00000:00000:2013/05/17 11:30:31.56 kernel Network and device connection limit is 9990.
00:00000:00000:2013/05/17 11:30:31.57 server Number of proc buffers allocated: 6188.
00:00000:00000:2013/05/17 11:30:31.61 server Number of blocks left for proc headers: 6120.
00:00000:00000:2013/05/17 11:30:31.63 server Proc header memory allocated 3060 pages for each per engine cache
00:00000:00000:2013/05/17 11:30:31.63 server Memory allocated for the default data cache cachelet 1: 44948 Kb
00:00000:00000:2013/05/17 11:30:31.64 server Size of the 2K memory pool: 44948 Kb
-- ASE 12.5.4 --
00:00000:00000:2008/04/02 13:54:41.81 kernel Network and device connection limit is 9985.
00:00000:00000:2008/04/02 13:54:44.48 server Number of blocks left for proc headers: 139912.
00:00000:00000:2008/04/02 13:54:44.99 server Proc header memory allocated 69956 pages for each per engine cache
00:00000:00000:2008/04/02 13:54:45.23 server Size of the 16K memory pool: 512000 Kb
00:00000:00000:2008/04/02 13:54:45.48 server Size of the 2K memory pool: 512000 Kb
00:00000:00000:2008/04/02 13:54:45.48 server Memory allocated for the default data cache cachelet 1: 1024000 Kb
00:00000:00000:2008/04/02 13:54:45.57 server Size of the 16K memory pool: 199680 Kb
00:00000:00000:2008/04/02 13:54:45.57 server Size of the 2K memory pool: 5120 Kb
00:00000:00000:2008/04/02 13:54:45.57 server Memory allocated for the dbccdb_cache cachelet 1: 204800 Kb
00:00000:00000:2008/04/02 13:54:45.57 kernel Enabling Sun Kernel asynchronous disk I/O strategy.
----------------
-- ASE 15.5 ----
00:00:00000:00000:2013/04/08 16:03:05.63 kernel Network and device connection limit is 9985.
00:00:00000:00000:2013/04/08 16:03:05.63 kernel ASE - Dynamic Pluggable Component Interface is disabled
00:00:00000:00000:2013/04/08 16:03:05.86 server Number of blocks left for proc headers: 100016.
00:00:00000:00000:2013/04/08 16:03:06.01 server Proc header memory allocated 20003 pages for each per engine cache
00:00:00000:00000:2013/04/08 16:03:06.01 kernel Enabling Sun Kernel asynchronous disk I/O strategy.
----------------
-- ASE 15.7 ----
00:0000:00000:00000:2013/05/08 16:06:01.84 kernel Network and device connection limit is 39985.
00:0000:00000:00000:2013/05/08 16:06:01.84 kernel ASE - Dynamic Pluggable Component Interface is disabled
00:0000:00000:00000:2013/05/08 16:06:01.84 kernel Adaptive Server is running as process id 9331.
00:0000:00000:00000:2013/05/08 16:06:02.42 server Number of blocks left for proc headers: 143912.
00:0000:00000:00000:2013/05/08 16:06:02.42 server Proc header memory allocated 899 pages for each per engine cache
00:0000:00000:00000:2013/05/08 16:06:02.43 server Proc header memory allocated 899 pages for engine 0 local cache
00:0000:00000:00000:2013/05/08 16:06:02.43 kernel Create Thread Pool 4, "syb_aio_pool", type="Run To Completion", with 0 threads
----------------
What happened to this message? How can I get information about memory usage in the procedure cache?
Read more...
Environment
SAP Sybase Adaptive Server Enterprise (ASE) 12.5.4 and higher
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.