Monitoring the Plan Cache
The Plan Cache table displays objects that are currently stored in the plan cache.
The plan cache contains executable plans for Transact-SQL, including objects such as stored procedures, triggers, views and defaults, as well as ad hoc and prepared SQL.
To improve performance, Foglight for SQL Server limits the number of records that can be displayed in this table to 300 rows, but by default, a maximum of 20 records are displayed.
Foglight for SQL Server retrieves the largest plan cache entries first, so if any entries are not displayed, they are the smallest ones.
Tracking Memory Allocation to the Plan Cache by Object Type
The Cache Size by Object Type chart displays the amount of memory allocated to the plan cache over time, and breaks it down by object type. This display allows viewing trends of plan usage, which can be used for improving the queries used for retrieving the plans.
Reviewing Statistics about Plan Cache Objects
The Object Types chart shows various statistics for each type of plan cache object.
The Object Types list can be used for selecting the metric to be displayed in this graph. Each metric is displayed for each type of plan cache object.
Reviewing the Instance Activity
The Activity drilldown provides access to graphs that display both current and recent activity details for the currently monitored SQL Server instance.
The first section contains instructions regarding the use of the various panels of the Activity drilldown for carrying out a root-cause analysis of possible performance issues. The following sections provide in-depth data about each panel.