SQL Server PerfMon counters for access methods and buffer manager

SQL Server PerfMon counters for access methods and buffer manager

Date: Apr 28, 2008

In part four of this screencast series on PerfMon, SQL Server MVP Kevin Kline focuses specifically on SQL Server counters. Kline shares best practices for using access method counters to watch for IO intensive operations, such as full table or clustered index scans and page splits. You'll also learn why it's important to monitor the buffer manager in SQL Server, that is, keep an eye on lazy writer, page utilization and how quickly pages age out of the buffer.

More on Microsoft SQL Server Performance Monitoring and Tuning

  • canderson

    Monitoring SQL Server disk I/O with PerfMon counters

    VIDEO - As a DBA, you need to understand the I/O of your SQL Server disk subsystem. In part three of this screencast series, learn how to track I/O in your direct-attached storage disks (DASD). Get optimal throughput values to keep an eye on when using Performance Monitor counters for physical disk reads and writes and disk queue length. Kline also shares some best practices you can't afford to miss.

  • canderson

    SQL Server PerfMon counters for Windows operating systems

    VIDEO - SQL Server PerfMon counters can help DBAs troubleshoot and even avoid bottlenecks on Windows operating systems. In part two of this screencast, learn the best practices and maximum values to watch for when using counters to monitor OS performance.

  • canderson

    SQL Server PerfMon counters for tracking Windows memory

    VIDEO - In part one of this series on the Performance Monitor tool (PerfMon), SQL Server MVP Kevin Kline walks you through significant PerfMon counters for tracking Windows memory.

  • xVelocity Columnstore Indexes in SQL Server 2012

    Tip - Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.

  • Maximize SQL Server database performance by streamlining your data

    Tip - Roman Rehak shows you some quick and easy ways to streamline and improve performance of your SQL Server databases.

  • Preparing for your SQL Server scale-out

    Tip - It's never too early to prepare for a SQL Server scale-out. Read this tip from Roman Rehak to learn three popular ways to scale out SQL Server.

  • Index tuning for the reluctant DBA

    Tip - Many reluctant DBAs find index tuning intimidating. Read this article by Don Jones to learn why index tuning is a must for your SQL Server shop.

  • database mirroring

    Definition - Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially compromised.
Back to top