How to integrate Performance Monitor and SQL Profiler

Next>>         SQL Server tutorial  

SQL Server - How to integrate Performance Monitor and SQL Profiler - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

How to integrate Performance Monitor and SQL Profiler.

Steps to integrate performance monitor and SQL Profiler:

• Create perfmon log file.
• Create SQL Profiler trace file
• Start SQL Profiler and open a trace file in it. The SQL Profiler trace file and perfmon log file should be time synchronized.
• File->import performance data and choose the perfmon log file that correlates with SQL Profiler tracefile.
• Select counters to be displayed from the dialog box

SQL Server - How to integrate Performance Monitor and SQL Profiler - May 05, 2009 at 22:00 PM by Rajmeet Ghai

How to integrate Performance Monitor and SQL Profiler.

In order to Integrate Performance Monitor and SQL Profiler, server performance needs to be captured simultaneously using both Performance Monitor’s Counter Logs and SQL Server Profiler. This can be done by following the steps below:

• The counters to be viewed should be configured in system monitor.
• The trace events should be configured using configure profiler including the start and end date. The profile should be saved and closed.
• The counter log should be now manually started followed by server side trace. Server side trace can be started by opening SQL profiler.
• Once the test is complete, counter Log and the server side trace along with SQL profiler should be stopped.
• By opening the profiler, the saved trace file can be opened.
• The counter log can also be imported using the File->Import Performance Data menu command.

SQL Server - How to integrate Performance Monitor and SQL Profiler - June 21, 2009 at 09:00 AM by Amit Satpute

How to Integrate Performance Monitor and SQL Profiler?

SQL Server profiler displays information about the SQL Server events.

The Windows System Monitor displays information about the server internals graphically.

The Performance Monitor’s Counter Logs and SQL Server Profiler’s event data need to be simultaneously captured to get the integrated information.

Steps to follow:

• Configure System Monitor with the counters are desired to be viewed.
• Set up the Counter Log with the same configuration.
• Then the Profiler needs to be configured with the set of trace events which need to include the start and end time data columns. This enables the Profiler to integrate the two logs later.
• Save and close the profiler.
• Manually start the Counter Log.
• Open SQL Profiler trace code to start the server-side trace.
• When the test is complete, stop both the counter Log and the server side trace. You need to stop the SQL Profiler which is a negative point in this.
• Open profiler and open the saved trace file.
• Use the File->Import Performance Data menu command to import the Counter Log.

Note: (Only the important counters from the performance monitor should be selected due to performance issues)

Next>>

Also read

Describe in brief SQL Server monitoring ways.

Answer - SQL Profiler is a tool that stores events from the server. SQL Profiler saves the events in the trace file......

SQL Profiler

What are the tasks performed by SQL Profiler?
How can you use the SQL Profiler to ensure database security?
How can you reduce the amount of data collected by a trace?
What is SQL Profiler?
When do you use SQL Profiler?............

What is the purpose of SQL Profiler in SQL server?

Answer - SQL Profiler captures SQL Server events from a server. The events are saved.....