Date: Fri, 29 Mar 2024 09:16:24 +0000 (UTC) Message-ID: <562383776.69843.1711703784759@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69842_219670288.1711703784754" ------=_Part_69842_219670288.1711703784754 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Memory tab displays the dynamic memory currently in use by S= QL Server as well as how that memory satisfies the requirements of SQL= Server components. For example, you can see what percentage of the to= tal allocated memory is currently used by the procedure cache. You can cont= rol the amount of memory SQL Server uses by either setting a fixed mem= ory value or setting minimum and maximum memory usage values.
Static structures, like procedure headers, use the amount of memory deri= ved from subtracting the sum of the graphed sections displayed on the Memor= y tab from the total allocated memory, also provided on the Memory tab.
To open the Memory view of the SQL Diagnostic Manager Resources tab, sel= ect the appropriate SQL Server instance, click Resources, and select Memory.
The following charts are available on the Memory tab:
Displays the SQL Memory Usage by what is = used by SQL Server compared to what is allocated and the total used.
Displays the memory usage by your virtual= machine and host as a percentage of total memory available.
Displays the memory pages per second.
Displays the memory usage of the Procedur= e Cache, Connections, Locks, Database, Optimizer, Sort, Hash, and Index.
Displays the amount of memory allocated t= o and used by SQL Server to the total memory consumed on this virtual = machine.
Displays the amount of memory allocated t= o and used by SQL Server to the total memory consumed on this host ser= ver.
Displays the hit ratios of the Buffer and= Procedure cache.
Displays the buffer cache used by Free an= d Active pages.
Provides the amount of allocated memory u= sed by dynamic and static stored procedures. Included in this value is the = memory used by server side cursors and plans. From the total memory allocat= ed to SQL Server, the pinned tables, open objects, connections, locks,= and free buffer values are subtracted. The remainder is divided between pr= ocedure and data cache.
Provides the time in seconds that a page = remains in the cache or buffer pool.
SQL Diagnostic Manager charts provide data whether collected real-time o= r as part of a scheduled collection event. For additional information about= how SQL Diagnostic Manager displays your chart data, see Charts.