Professional SQL Server® 2012 Internals and Troubleshooting by Christian Bolton Justin Langford Glenn Berry Gavin Payne Amit Banerjee & Rob Farley
Author:Christian Bolton, Justin Langford, Glenn Berry, Gavin Payne, Amit Banerjee & Rob Farley
Language: eng
Format: mobi
Published: 0101-01-01T00:00:00+00:00
268 ❘ CHAPTER 10 VIEWING SERVER PERFORMANCE WITH PERFMON AND THE PAL TOOL
Getting Started with PerfMon
PerfMon is a component of Reliability and Performance Monitor which can be launched from Start
➪ All Programs ➪ Administrative Tools. Alternatively, just type perfmon into the Run box and press Enter.
As mentioned earlier, PerfMon is a Windows monitoring tool, and as such it can be used to monitor any application — from Microsoft Exchange to Windows itself. When an application is installed,
performance counters are registered and you can monitor the counters in real time or trace them
to a log fi le. PerfMon isn’t designed specifi cally for SQL Server, so you need to add the relevant Windows and SQL Server counters to a log fi le in order to view resource utilization and SQL Server activity.
Monitoring Real-Time Server Activity
One of the most common uses for PerfMon is viewing real-time server activity. PerfMon provides
data instantly on system workload, performance, and resource consumption. By reading the data
presented by PerfMon, you can rapidly narrow the scope of a problem.
Within Reliability and Performance Monitor, select Performance Monitor from the Monitoring
Tools folder. You’ll be presented with a line chart plotting percentage of processor time from your own computer, as shown in Figure 10-2. In this section, you’ll add a few counters to get a feel for CPU, disk, and memory activity on your PC.
FIGURE 10-2
c10.indd 268
10/3/2012 3:36:52 PM
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
| Access | Data Mining |
| Data Modeling & Design | Data Processing |
| Data Warehousing | MySQL |
| Oracle | Other Databases |
| Relational Databases | SQL |
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8304)
Azure Data and AI Architect Handbook by Olivier Mertens & Breght Van Baelen(6767)
Building Statistical Models in Python by Huy Hoang Nguyen & Paul N Adams & Stuart J Miller(6743)
Serverless Machine Learning with Amazon Redshift ML by Debu Panda & Phil Bates & Bhanu Pittampally & Sumeet Joshi(6629)
Data Wrangling on AWS by Navnit Shukla | Sankar M | Sam Palani(6412)
Driving Data Quality with Data Contracts by Andrew Jones(6352)
Machine Learning Model Serving Patterns and Best Practices by Md Johirul Islam(6117)
Learning SQL by Alan Beaulieu(5999)
Weapons of Math Destruction by Cathy O'Neil(5785)
Big Data Analysis with Python by Ivan Marin(5375)
Data Engineering with dbt by Roberto Zagni(4380)
Solidity Programming Essentials by Ritesh Modi(4027)
Time Series Analysis with Python Cookbook by Tarek A. Atwan(3888)
Pandas Cookbook by Theodore Petrou(3593)
Blockchain Basics by Daniel Drescher(3302)
Hands-On Machine Learning for Algorithmic Trading by Stefan Jansen(2911)
Feature Store for Machine Learning by Jayanth Kumar M J(2816)
Learn T-SQL Querying by Pam Lahoud & Pedro Lopes(2799)
Mastering Python for Finance by Unknown(2746)
