#perfmon

Relog is a great, probably underutilized utility that ships with Windows (\Windows\System32\). It lets you take just about any system performance log file and convert it to a number of formats (including dumping them into SQL). It also supports resampling, however the resampling (with -t) does not involve any sort of statistical operation; it just takes every nth sample. For example, a 1-min interval log with -t 60 specified would take every 60th sample in the log, effectively giving you a 1-hour interval.

Converting perfmon blg files to csv:

\nrelog logfile.blg -f csv -o logfile.csv

Importing to a SQL store requires first that you create a SQL Server ODBC DSN:

\nrelog logfile.blg -f sql -o SQL:!

Taking a logfile with 1 minute sample frequency and resample to a 1 hour frequency csv:

Table of Contents 

1 Introduction 2 Processor 3 Physical Memory

3.1 \Memory\Available Bytes 3.2 \Process(_Total)\Working Set 3.3 \Memory\Cache Bytes 3.4 \Memory\Pool Nonpaged Bytes 

4 Paging

4.1 \Memory\Pages/sec 4.2 \Memory\Page Reads/sec 4.3 \Memory\Page Writes/sec 4.4 \Paging File(_total)\% Usage 

5 CPU/System Stats

5.1 \Processor(_total)\% Privileged Time 5.2 \Processor(_total)\% User Time 5.3 \System\Processor Queue Length 

6 Disk Throughput

6.1 \PhysicalDisk(*)\Disk Read Bytes/sec 6.2 \PhysicalDisk(*)\Disk Write Bytes/sec 

7 Disk Queue Length

7.1 \PhysicalDisk(*)\Avg. Disk Queue Length 7.2 \PhysicalDisk(*)\Current Disk Queue Length 

8 Disk Latency and Fragmentation

8.1 \PhysicalDisk(*)\Avg. Disk sec/Read 8.2 \PhysicalDisk(*)\Avg. Disk sec/Write 8.3 \PhysicalDisk(*)\Split IO/sec 

9 Network Throughput

9.1 \Network Interface(*)\Bytes Received/sec 9.2 \Network Interface(*)\Bytes Sent/sec 

10 IIS / Webservice Counters

10.1 \Web Service(_Total)\Current Connections 10.2 \Web Service(_Total)\Current Anonymous Users 10.3 \Web Service(_Total)\Current NonAnonymous Users 10.4 \Web Service(_Total)\Get Requests/sec 10.5 \Web Service(_Total)\Put Requests/sec 10.6 \Web Service(_Total)\Post Requests/sec 

11 SQL Server Usage Stats

11.1 \SQLServer:General Statistics\User Connections 11.2 \SQLServer:SQL Statistics\SQL Compilations/sec 11.3 \SQLServer:SQL Statistics\SQL Re-Compilations/sec 11.4 \SQLServer:SQL Statistics\Batch Requests/sec 11.5 \SQLServer:Databases(_total)\Log Flushes/sec 11.6 \SQLServer:Buffer Manager\Lazy Writes/sec 11.7 \SQLServer:Access Methods\Page Splits/sec 

12 SQL Server Memory

12.1 \SQLServer:Buffer Manager\Buffer cache hit ratio 12.2 \SQLServer:Memory Manager\SQL Cache Memory (KB) 12.3 \SQLServer:Memory Manager\Total Server Memory (KB) 12.4 \SQLServer:Memory Manager\Target Server Memory (KB) 

13 SQL Server Stats

13.1 \SQLServer:General Statistics\Processes Blocked 13.2 \SQLServer:Locks(_total)\Number of DeadLocks/sec 13.3 \SQLServer:Locks(_total)\Average Wait Time (ms) 13.4 \SQLServer:Latches\Average Latch Wait Time (ms) 

14 Individual Process Statistics

Windows Perfmon To Determine Performance For iSCSI

[ad_1] The performance monitor is a utility used to track a range of processes and give a real time graphical display of the results Windows 2003 system. This tool can be used to assist you with the planning of upgrades, tracking of processes that need to be optimized, monitoring results of tuning and configuration scenarios, and the understanding of a workload and its effect on resource usage to…

If you have to manage performance on a linux server, this new web based monitoring tool is really simple and looks good.

I’ve had an interesting problem at work where I needed to capture high-resolution perfmon counters samples in order to highlight better an IO consumption issue. Sampling in something like Operations Manager or resource metering just didn’t cut is as the data was too averaged out. This meant we were losing significant IO spikes. At first, to get a better feeling of the data, I used my friend…

Fixed: Is there an automated way of collating data from Perfmon? #programming #solution #development

Is there an automated way of collating data from Perfmon?

I’ve been manually collating Perfmon data (e.g., getting screen caps of the perfmon graph to get the average, min, max values) of statistics like % processor usage, % committed bytes in memory, etc in profiling an ASP.NET application for server sizing.

I’d like to know if there’s a way to automate this, e.g., get specific perfmon…

How-to: Find the bottleneck: disk I/O on Windows XP #dev #development #solution

Find the bottleneck: disk I/O on Windows XP

One of our development boxes has developed a problem wherein performance will occasionally drop through the floor. When this happens, you can hear the hard drive thrashing, but I don’t know what’s causing it.

This happens during periods of high disk access (reading/writing multi-gigabyte files), but not every time nor for the entire period of disk…