Resource and Help for Microsoft SQL Server Profiler Tool

Send a Message


 

 

 


 
  

Need help with Microsoft SQL Server? Ask our Experts, or simply Email your query.

About Sql Server Programmers

Our clients can be found both locally in the Chicagoland area and throughout the country. We have over 16 years of experience and are extremely proud of our track record of successfully assisting hundreds of our clients to improve their productivity while focusing on cost.

Microsoft Certified Partner

  

SQL Server Profiler

There are times that you may want to see what SQL queries are running on your SQL Server database to evaluate its performance.  SQL Server Profiler helps you monitor your SQL Server.  It is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services.  You can use this tool to see which queries are performing well and which needs to be rewritten to better meet your performance needs.  You can capture and save data about each event to a file or table to analyze later.  You start by opening SQL Server Profiler and select new trace.  Your screen should look similar to the image below.

New Trace

Profiler will display some options that you can select for the trace.  These options Include the following.

  1. Naming the trace
  2. Using a template
  3. Saving the trace information to a file
  4. Saving the trace information to a table
  5. Enable a trace stop time

You will also be able to select the SQL Server Events that you want to capture.

Trace Event Options

Once you configure all of the filters to narrow your search.  The SQL Server Profiler will record and/or display all inquiries to the SQL Server that meet your criteria.