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