SAP Knowledge Base Article - Preview

3377053 - sp_sysmon reports NV Cache section when no NV Cache is configured - SAP ASE

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
          Total Cache Hits                %
          Total Cache Misses              %
      -------------------------  ------------  ------------  ----------
        Total Cache Searches

    Example 2 where the empty User Defined NV Cache is printed:

      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

SAP Adaptive Server Enterprise 16.0

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.