Contact  |  Site Map  |  Privacy      Call for more info
 

SQL Trace Analyzer allows you to easily correlate and compare Performance Monitor logs with analyzed traces, giving you an overall picture of your database server’s resource utilization and performance.

              

 Step 1 of 2: To correlate a PerfMon log, in the Activity Graph tab of your trace, click on the  “Open PerfMon Log” toolbar button, then browse to the location of the file and select the PerfMon log that you wish to open.

               

                Fig. 01

 

Step 2 of 2: To add a PerfMon counter that you wish to display in the trace’s activity graph, click on the “PerfMon Column” toolbar button then select it from the list of available counters.

                               

                Fig. 02

 

  The counter will then be displayed in the graph together with the trace’s activity.

                               

                Fig. 03  

                               

The ability to correlate PerfMon logs with traces is a very useful feature of SQL Trace Analyzer that helps you determine resource consumption of your database server outside the activity of your database.

Here, we can see the following comparison in CPU utilization between the trace and the PerfMon log:

Date and Time

Trace Statistics

PerfMon Statistics

Overall vs. DB Activity

7/1/2007 6:05 AM

~2000

~11000

+9000

7/1/2007 6:10 AM

~2000

~7000

+5000

7/1/2007 6:15 AM

~11000

~16000

+5000

7/1/2007 6:20 AM

~13000

~16000

+3000

7/1/2007 6:25 AM

~16000

~17000

+1000

7/1/2007 6:30 AM

~12000

~15000

+3000

7/1/2007 6:35 AM

~12000

~18000

+6000

7/1/2007 6:40 AM

~14000

~18000

+4000

7/1/2007 6:45 AM

~7000

~17000

+10000

 

The sample results above tell us that overall CPU utilization is significantly higher than that of the database activity. This indicates that other processes outside the scope of the trace were highly consuming the database server’s CPU resources. These could be processing requests from the operating system or other applications processes running on the database server.

SQL Trace Analyzer is able to display any counter in a PerfMon log and allows you to correlate resource utilization and performance in other areas such as IO activity and memory usage.