In this episode of the screencast series "PerfMon Counters for the SQL Server DBA," 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.
This is cache of http://feeds.feedburner.com/~r/WhatisEnterpriseItTipsAndExpertAdvice/~3/280223302/0,295582,sid87_gci1310036,00.html. Cache is the snapshot of article that we took when we index feed.
To see original page click here.
We are not affiliated with the authors of this article and not responsible for its content.
To see original page click here.
We are not affiliated with the authors of this article and not responsible for its content.
SQL Server PerfMon counters for access methods and buffer manager
 |  |
 |  |
 |  |
 |
BROWSE CATEGORIES
TOP SEARCH
RECENT SEARCH
RELATED VIDEO
