Free pages values that are consistently close to zero may indicate use of inefficient queries, or shortage of SQL Server cache memory. The value of the Free Pages metric is calculated as follows: <free pages> * 8K / 1024. For details, see Free pages .
Constantly high value of stolen pages (pages that were taken from the buffer cache to satisfy other memory requests) may indicate an overall system memory shortage. For details, see Stolen pages .
The Buffer Cache Hit Rates chart displays the buffer cache hit rate over the specified time range.
The Plan Cache panel displays information about the SQL Server's plan cache, which holds execution plans for stored procedures, triggers, ad hoc SQL, and so on. This panel can be used for tracking the plan cache hit rate, and, if the rate it too low, investigate which object plans are used frequently.
The various panes of the Plan Cache panel allow carrying out the tasks described in the following sections:
In SQL Server 2005 and later versions, the following object types can appear in the chart:
• |
Bound Trees — normalized trees for views, rules, computed columns, and check constraints. For details, see glossary definition of Bound trees . |
• |
Extended Stored Procedures — a SQL Server object that dynamically loads and runs a function within a dynamic-link library (DLL) in a manner similar to a stored procedure. For details, see glossary definition of Extended stored procedures . |
• |
Object Plans — query plans generated by creating a stored procedure, function, or trigger. For details, see glossary definition of Object plans . |
• |
Replication Procedure Plans — query plans of a replication system stored procedure. For details, see glossary definition of Replication procedure plans . |
• |
• |
Temporary Tables and Table Variables — temporary tables are session-specific tables, that is, the tables are automatically dropped when the session is closed. Table variables, on the other hand, are created in the memory and exist there until the running of a single Transact-SQL (T-SQL) batch is completed. For details, see glossary definition of Temporary tables and table variables . |
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center