.Net Web App Performance - Important performance counters

DotNet_WebApp_Performance_Performance_Counters.md

System

Applies to - Web Server, Application Server & Database server

Counter	Instance	Object	Description
Processor Queue Length		System	Official link
% Processor Time	_Total	Processor Information
Available MBytes		Memory
% Processor time	w3wp##	Process
ID Process	w3wp##	Process
Thread Count	w3wp##	Process
Private Bytes	w3wp##	Process
Avg. Disk Queue Length	_Total	PhysicalDisk	Requests waiting

Network

Counter	Instance	Object
Bytes Received/sec		Network Interface
Bytes Sent/sec		Network Interface
Bytes Total/sec		Network Interface
Current bandwidth		Network Interface
Output Queue Length		Network Interface

• https://blogs.msdn.microsoft.com/spatdsg/2011/06/24/dc-fails-logons-or-experiences-ldap-timeouts/
• https://blogs.technet.microsoft.com/askds/2007/08/20/troubleshooting-high-lsass-cpu-utilization-on-a-domain-controller-part-1-of-2/
• https://itworldjd.wordpress.com/2019/01/24/how-to-monitor-ldap-queries/

IIS

• https://stackify.com/asp-net-performance-counters/
• https://stackify.com/how-to-monitor-iis-performance/

.Net

Counter	Instance	Object
% Time in Jit	w3w3##	.Net CLR Jit
Current Queue Length	w3w3##	.Net CLR LocksAndThreads
Total # of Contentions	w3w3##	.Net CLR LocksAndThreads
# Bytes in all Heaps	w3w3##	.NET CLR Memory
% Time in GC	w3w3##	.NET CLR Memory
Large Object Heap size	w3w3##	.NET CLR Memory

https://docs.microsoft.com/en-us/dotnet/framework/debug-trace-profile/performance-counters

ASP.Net

Counter	Instance	Object
Request Execution Time		ASP.Net Applications
Request Wait Time		ASP.Net Applications
Requests In Application Queue		ASP.Net Applications
Requests/Sec		ASP.Net Applications

ADO.Net

• https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/performance-counters

Inside SQL Server

Counter	Instance	Object	Description
Logins/sec		MSSQL${Instance}:General Statistics
User Connections		MSSQL${Instance}:General Statistics
SQL Compilations/sec		MSSQL${Instance}:SQL Statistics	Shows the compilations
SQL Re-Compilations/sec		MSSQL${Instance}:SQL Statistics	Shows the Re-compilations if there are dynamic queries
Cache Object Counts	SQL Plans	MSSQL${Instance}:SQL Plans
Cache Objects in use	SQL Plans	MSSQL${Instance}:SQL Plans
Cache Hit Ratio	SQL Plans	MSSQL${Instance}:SQL Plans

Locks

Counter	Instance	Object	Description
Average Wait Time(ms)	_Total	MSSQL${Instance}	Avg wait time for the callers that ended up in wait.
Lock Requests/sec	_Total	MSSQL${Instance}	New lock requests
Lock Waits/sec	_Total	MSSQL${Instance}	# lock requests/s that make the caller to wait

Official link

Applicable to Always On Availability Groups

Counter	Instance	Object	Description
Mirrored Write Transactions/sec	_Total	MSSQL${Instance}:Database Replica
Transaction Delay	_Total	MSSQL${Instance}:Database Replica	Divide by Mirrored Write Transaction/sec to get Avg Transaction Delay

• https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2003/cc781394(v=ws.10)
• http://www.appadmintools.com/documents/windows-performance-counters-explained/
• https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/use-sql-server-objects?view=sql-server-2017

References

• https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2003/cc781394(v=ws.10)
• http://www.sqlserverfaq.net/2011/01/31/what-perfmon-counters-should-i-monitor-and-what-each-of-them-mean/
• https://docs.microsoft.com/en-us/windows-server/networking/technologies/network-subsystem/net-sub-performance-counters