Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters

Posted on SQL Server Central See other posts from SQL Server Central
Published on Thu, 13 Jan 2011 07:00:00 UT Indexed on 2011/01/13 15:57 UTC
Read the original article Hit count: 243

Filed under:
I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?
SQL Backup Join SQL Backup’s 35,000+ customers
to compress and strengthen your backups

"SQL Backup will be a REAL boost to any
DBA lucky enough to use it." Jonathan Allen.
Download a free trial now.

© SQL Server Central or respective owner