Page History
...
Static structures, like procedure headers, use the amount of memory derived from subtracting the sum of the graphed sections displayed on the Memory tab from the total allocated memory, also provided on the Memory tab.
Access the Memory view
You can To open the Memory view of the SQL Diagnostic Manager Resources tab by selecting , select the appropriate SQL Server instance, click Resources, and then clicking Resources > select Memory.
Memory tab charts
The following charts are available on the Memory tab:
...
Displays the memory usage of the Buffer Cache, Procedure Cache, Connections, Locks, Database, Optimizer, Sort, Hash, and OptimizerIndex.
VM Memory Areas
Displays the amount of memory allocated to and used by SQL Server to the total memory consumed on this virtual machine.
...
SQL Diagnostic Manager charts provide data whether collected real-time or as part of a scheduled collection event. For additional information about how SQL Diagnostic Manager displays your chart data, see Charts.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...