As a DBA, you need to understand disk behavior, that is, the I/O of your SQL Server disk subsystem. In part 3 of this screencast series, "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline explains how to track I/O in your direct-attached storage disks (DASD). You'll learn optimal throughput values to keep an eye on when using Performance Monitor counters for physical disk reads and writes and disk queue length. Get answers to questions including:
- How effective is PerfMon with storage area networks (SANs)?
- What's the I/O difference between non-cached writes and cached writes?
- How can I utilize PerfMon counters for tracking disk queue length?
- Why shouldn't I forget the effect of checkpoints on DASD reads and writes?
Kline answers these questions and more, as well as shares some best practices you can't afford to miss.
Sreencast series: PerMon counters for the SQL Server DBA
Part 1: SQL Server PerfMon counters for tracking Windows memory
Part 2: SQL Server PerfMon counters for Windows operating system (OS)
Part 3: Monitor SQL Server disk I/O with PerfMon counters
Part 4: SQL Server PerfMon counters for access methods and buffer manager
ABOUT THE AUTHOR: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring on the SQL Server platform. Kevin is the President of the international Professional Association for SQL Server (PASS). He has been a Microsoft SQL Server MVP since 2004. Kevin is the lead author of "SQL in a Nutshell" and a co-author of "Professional SQL Server 2005 Database Design & Optimization" and "Database Benchmarking." Kevin writes the monthly SQL Server Drilldown column for Database Trends & Applications and blogs at SQL Server Magazine and SQLBlog.com. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections. When he's not pulling his hair out over work, he loves to spend time with his four kids and in his flower and vegetable gardens.
This was first published in April 2008