Compaq ProLiant 1000 Configuration and Tuning of Sybase System 11 for NetWare - Page 16

Page 12 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers transactions per minute, normalized CPU % idle 1.00 0.90 0.80 0.70 0.60 0.50 0.40 0.30 0.20 0.10 0.00 1.00 2.00% 1024 Sybase System 11 on NetWare 4.10 0.91 0.73 9.00% 3.00% 768 512 system memory in MB 27.00% 30.00% 25.00% 0.56 20.00% 15.00% 10.00% 5.00% 0.00% 256 Estimating Memory Requirements for Stored Procedures Sybase divides the total memory into two areas, procedure cache and data cache. The amount of memory allocated to the procedure cache is defined as a percentage of the allocation for total memory. To properly configure the size of the procedure cache you need to know the memory requirements of each stored procedure. To estimate the memory requirements of a stored procedure, you execute the procedure and then use the dbcc memusage command to list the resources used by the stored procedure. Take the number of plan bytes and divide by the number of plans to get the number of bytes per plan. Divide the number of bytes per plan by 2048 bytes per Sybase page to get the number of Sybase 2K pages. Do this for each stored procedure, total the number of pages utilized and increase or decrease the setting of the sp_configure procedure cache accordingly. To estimate the memory requirements for a stored procedure without executing it. Execute the following isql command: select (count(*) / 8) + 1 from sysprocedures where id = object_id ("procedure_name") The query returns the number of Sybase 2K pages required by the stored procedure to execute. Do this for each stored procedure, total the number of pages utilized and increase or decrease the setting of the sp_configure procedure cache accordingly. Refer to the Sybase SQL Server Performance and Tuning Guide for more detailed information. I/O Tuning In most well tuned Sybase systems, I/O is not a limiting factor. In order to assure that this is not a problem, the following factors need to be verified. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896