Home > SQL Server PerfMon counters for Windows operating system (OS)
Screencast:
EMAIL THIS LICENSING & REPRINTS

SQL Server PerfMon counters for Windows operating system (OS)

17 Mar 2008 | Kevin Kline

Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

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.



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
SQL Server performance and tuning
SQL Server errors, failures and other problems fixed from the trenches
SQL Server database design disasters: How it all starts
Can you shrink your SQL Server database to death?
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
SQL Server database design disasters: What not to do
Tuning SQL Server performance via memory and CPU processing
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Ordering the results of a SQL query
Configuring SQL Server with a changed computer name
Change data capture in SQL Server 2008 improves BI reporting accuracy

SQL Server overview
Can you shrink your SQL Server database to death?
Physical data storage in SQL Server 2005 and 2008
SQL Server 2008 data types: Datetime, string, user-defined and more
SQL Server and data manipulation in T-SQL
Supertype and subtype tables in SQL Server
Enforcing data integrity in a SQL Server database
SQL Server database design disasters: What not to do
Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
Tuning SQL Server performance via memory and CPU processing
FAQ: How to troubleshoot and grant SQL Server permissions
SQL Server overview Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
contiguity  (SearchSQLServer.com)
contiguous  (SearchSQLServer.com)
drilldown  (SearchSQLServer.com)
hashing  (SearchSQLServer.com)
hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts