Compress Plan Cache Entries in Memory

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: 4.2.5
    • Component/s: Index Maintenance
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently plan cache entries contain a host of useful information that is useful for debugging through $planCacheStats for example. However, very complex plans can contribute significantly to memory use.

      Storing extra plan diagnostics compressed in the plan cache and decompressing when requested by $planCacheStats or other plan cache examination methods could dramatically decrease the memory footprint of the plan cache while retaining

              Assignee:
              Unassigned
              Reporter:
              Kevin Arhelger
              Votes:
              0 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated: