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.
SAP Knowledge Base Article - Preview