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.
  • Enbridge Inc. to virtualize all its servers

    Feature - Energy company Enbridge Inc. is in the process of virtualizing all of its servers to increase flexibility and cut costs. Not everyone is happy with this new direction.
  • Mavis Tire goes SANless with SIOS DataKeeper

    Feature - With DBAs rewarded for server performance and SAN specialists rewarded for server capacity, there can be a tug of war. Mavis Tire goes SANless with SIOS DataKeeper. SIOS Technology releases a survey about high availability and SAN.
  • When it comes to database security, beware lazy developers

    Feature - Don Jones discusses how database developers are taking the easy road for database security and going with the lowest common denominator instead of taking into account the unique security of each database platform.
  • The top three SQL Server third-party tools

    Feature - Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks.
  • The dark side of Microsoft SQL Server Express

    Tip - Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition.

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: