SQL Server PerfMon counters for Windows operating system (OS)

SQL Server PerfMon counters can help troubleshoot and even avoid bottlenecks on your Windows operating system. In part 2 of this screencast series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through best practices and maximum values to watch for when using counters to monitor OS performance.

SQL Server PerfMon counters can help troubleshoot and even avoid bottlenecks on your Microsoft Windows operating system (OS). In part 2 of this screencast series on "PerfMon counters for the SQL Server DBA," you'll learn specific counters to track when monitoring system performance. SQL Server MVP Kevin Kline walks you through best practices and maximum values to watch for when using PerfMon counters including percent usage for page files, processor counters to monitor CPU and server activity on both SQL Server and Analysis Services and lastly the Network Interface Bytes Total/sec counter for monitoring input and output of each NIC installed in the physical box.

 


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 IO 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 March 2008

Dig deeper on SQL Server Migration Strategies and Planning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

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:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close