We are in process of enabling both TDE and EFS on our DBs. In process of performance benchmarking to understand how sql server is behaving on current hardware pre and post , we are using perfmon or any third party tool which we use for resource performance counters .. they give us only average of counter values and not spikes whenever the Processor Time or Available MBytes hit 99% or above values ... correct ? If I am wrong please correct me ..
My question is how to look at even when and at what time the processor or RAM is at highest point ? Kindly advise and correct my understanding.