homeproductssql trace analyzerwalkthrough
Steps
You can identify the spids, procedures or queries, responsible for the spikes on the Perfmon graph.