.png?width=100&auto=webp&quality=80&disable=upscale "Picture of John Savill")
.png?width=400&auto=webp&quality=80&disable=upscale "John Savill")
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Q: How can I tell how much memory SQL Server 2008 is using?
John Savill
March 7, 2011
1 Min Read
A: There are several performance counters that can be used to evaluate how much memory SQL Server 2008 is using and is allowed to use.
Start Performance Monitor and add these counters:
SQL Server:Memory Manager - Target Server Memory (KB)
SQL Server:Memory Manager - Total Server Memory (KB)
SQL Server:Buffer Manager - Total pages
SQL Server:Buffer Manager - Free pages
SQL Server:Memory Manager - Total Server Memory (KB) and SQL Server:Buffer Manager - Total pages show the same value—one is in pages, so multiply the Total pages number by 8 (page size of 8KB) to get the actual memory, which should be the same value as Total Server Memory (KB).
About the Author
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
