Symptom
- Running the stored procedure sp_sysmon and the NV Cache detail section is printed even when no NV Cache is configured.
- The section "Cache: User Defined NV Cache" is printed as an existing NV Cache even though it isn't a valid cache and is always present with or without a configured NV Cache.
Example 1 where the empty All NV Caches is printed:
NV Cache Management
---------------------Cache Statistics Summary (All NV Caches)
----------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------Cache Search Summary
Example 2 where the empty User Defined NV Cache is printed:
Total Cache Hits %
Total Cache Misses %
------------------------- ------------ ------------ ----------
Total Cache Searches
Cache: User Defined NV Cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %Utilization n/a n/a n/a %
Cache Searches
Cache Hits %
Cache Misses %
------------------------- ------------ ------------ ----------
Total Cache Searches
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
CR828414, CR#828414, 828414 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
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.