Performance Test Performance counters

Test environment Setup

To configure Performance Monitor:

Run--perfmon to bring up the default performance Monitor

Run the--mmc-file Add Delete snap-in--Select Performance Monitor Add--save in Administrative tools in the next MMC can file--open

Common Performance monitoring counters:

Object	Counter	Description
. NET CLR Exceptions	# of Exceps Thrown/sec	Displays the number of exceptions thrown per second. This includes. NET exceptions and non-managed exceptions that are converted to. NET exceptions. Performance decreases as this number increases.
. NET CLR Memory	# Bytes in all Heaps	Shows the sum of the other four counters: gen 0 heap Size, gen 1 heap size, Gen 2 heap size, and large object heap size. This counter represents the currently allocated memory (in bytes) on the GC heap. The value of this counter is always smaller than the value of Process\Private Bytes, Process\Private Bytes counts the Mem_commit area of the process. Private Bytes minus # Bytes in all heaps is the number of bytes committed by an object that is not managed. Used to monitor for possible memory leaks, or to monitor whether the memory usage of managed or non-managed objects is too large.
. NET CLR Remoting	Remote calls/sec	Displays the number of remote procedure calls that are invoked per second. A remote procedure call is a call to any object outside the application domain where the caller resides. This counter is not an average for a period of time, it shows the difference between the last two sample observations divided by the sampling interval.
. NET Data Provider for Oracle	Numberoffreeconnections	The number of connections available in the connection pool.
. NET Data Provider for SQL Server	Numberoffreeconnections	The number of connections available in the connection pool.
Process	% Processor Time	Displays the percentage of the used processor time that is used by all process threads to execute instructions. An instruction is a basic unit of execution in a computer, a thread is an object that executes instructions, and a process is an object that is created when a program is run. This count contains code that executes when some hardware interrupts and trap conditions are handled. If the total processor time is longer, use this counter to determine which processes are causing high CPU utilization.
Process	Handle Count	Displays the total number of handles currently open by this process. This number is the total number of handles currently open by each thread in this process. The increase in the handle count in a particular process may be the symptom of the error process that occurs with a handle leak, which causes a performance problem on the server. This issue does not necessarily occur, but it is important to monitor it for a period of time to determine whether a handle leak occurs.
Process	Thread Count	The number of threads that are active in this process. An instruction is a basic unit of execution in a processor, and a thread is an object that executes instructions. Each running process has at least one thread.
Sqlserver:general Statistics	User Connections	Displays the current number of connections to SQL Server, not the number of users. If the counter exceeds 255, then you need to set the configuration value of SQL Server's Maximum Worker Threads to be higher than the default value of 255. If the number of connections exceeds the number of threads available, SQL Server shares the threads, which can affect performance. "Maximum Worker Threads" needs to be set higher than the maximum number of connections your server has ever reached.
Sqlserver:locks	Number of Deadlocks/sec	The number of deadlocks/sec, deadlocks are very harmful to the scalability of the application and can lead to a poor user experience. The value of this counter must be 0.
LogicalDisk	% Free Space	% Free space is the percentage of the total available room on the selected logical disk drive.
PhysicalDisk	Disk Read bytes/sec	Refers to the rate at which bytes are transferred from disk during a read operation.
PhysicalDisk	Disk Write bytes/sec	Refers to the speed of bytes that are transferred to a disk during a write operation.

Performance Test Performance counters