Profiling a workload means determining what work each user is actually performing.
Performance Monitor provides a variety of counters for this purpose.
These counters are similar to the counters in the [Processor] object,
but in this case they are used to collect process data.
These counters can be found in the Process object and include the following:
* % Processor Time
Percentage of elapsed time during
which all of the threads of this process used the processor to execute instructions.
Code executed to handle certain hardware interrupts or trap conditions may be counted for this process.
* % User Time
Percentage of elapsed time this process's threads have spent executing code in User mode.
* % Privileged Time
Percentage of elapsed time that this process's threads have spent executing code in Privileged mode.
* Page Faults/sec
Rate of page faults by the threads executing in this process.
* Elapsed Time
Total elapsed time (in seconds) the process has been running.
Source:
Microsoft SQL Server 2000 Administrator's Companion eBook