SAP Note 902892 - Procedure cache hit ratio seems strange

Symptom

In a 620 basis system, the procedure cache hit ratio seems strange or inconsistent with historical values.  In later releases SAP download tools record strange results for procedure cache hit ratio.

Other terms

GET_SQLPERFCACHE_MSQ, GET_SQLPERFCACHE_MSS, Procedure cache hit ratio, RSMSQ000, ST04 main screen

Reason and Prerequisites

The term procedure cache hit ratio really covers a variety of SQL Server items; Misc. Normalized Trees, Execution Contexts, Cursors, Adhoc Sql Plans, Prepared Plans, Procedure Plans, Trigger Plans, etc.
They are all averaged together to create a TOTAL hit ratio.  In 620, the TOTAL value was not displayed on the main screen of ST04.  Instead whatever subcomponent was listed first was displayed.

Solution

Please implement the following source code correction

Header Data

Release Status:	Released for Customer
Released on:	02.12.2005  22:34:29
Master Language:	English
Priority:	Correction with medium priority
Category:	Program error
Primary Component:	BC-DB-MSS Microsoft SQL Server

Affected Releases

Software Component Release From Release To Release And subsequent SAP_BASIS 60 620 640 SAP_BASIS 70 700 700

Correction delivered in Support Package

Support Packages Release Package Name SAP_BASIS 620 SAPKB62058 SAP_BASIS 640 SAPKB64016 SAP_BASIS 700 SAPKB70007

Corrections Instructions

Correction Instruction Valid from Valid to Software Component Last Modifcation 446333 640 640 SAP_BASIS 02.12.2005  16:31:40 446334 700 700 SAP_BASIS 02.12.2005  16:32:03 448693 620 620 SAP_BASIS 02.12.2005  22:27:06

Download original format @ https://service.sap.com/sap/support/notes/902892