PERFMONPerformance Monitor
Copyright 1988-2018, All rights reserved.
References in periodicals archive ?
We also use Perfmon 2 to measure the events, including CPU_CLK_UNHALTED, INST_RETIRED, and LAST_LEVEL_CACHE_MISSES, and call the getcycles function to get the number of cycles including both halted and unhalted cycles.
Here's what some of the case-sensitive switches and trace flags mean: -c shortens startup time when starting SQL Server from the command prompt, by telling SQL Server to skip the step used to start SQL Server as a Microsoft Windows service; -x disables most of the important, built-in monitoring features such as PerfMon counters, CPU and cache-hit ration statistics, and a wide variety of internal system metadata, forcing you to lose a boatload of troubleshooting and performance-tuning information; and -E increases the number of extents that are allocated for each file in a filegroup, which is good for data warehouses with relatively few users running data scans but probably bad for OLTP applications.
For example, I recently created a popular poster for Quest Software that shows all of the most meaningful and useful Windows Performance Monitor (PerfMon) counters.