A poorly constructed TSQL using excessive resources can affect the performance of tempdb. By following the most expensive branches you can find the performance bottleneck. Performance Testing Types Steps Best Practices And Metrics Also we can identify the bottleneck by using auto-correlating feature. . Measure the current performance to create a performance baseline to compare with your future measurements and to identify system bottlenecks. Finding performance bottlenecks in application NET Code is very important. The first is the addition of noise reduction options. If load average starts increasing beyond a limit it means that the number of processes in the queue starts increasing see points to remember section below. You can use Performance Monitor to check the load on your CPU. In my example simply by measuring the performance once we were able to detect and fix a piece of our code that was responsible for a very sign...