Start SQL Server Provider in Management Studio

SQL Server Profiler is an interface that allows you to create and manage traces. The events are saved in a trace file that can later be analyzed to determine the cause of a problem. In this article I will explain how to start SQL Server Profiler in Management Studio.

SQL Server Management Studio starts each profiler session in its own instance and continues to run if you shutdown SQL Server Management Studio.

Start SQL Server Profiler from the Tools menu

1. Open Management Studio, start by connecting to the server.

2. In the Management Studio, go to menu “Tools -> SQL Server Profiler“:

tools menu

Start SQL Server Profiler from the Query Editor

1. Click on New Query to open the editor:

click query editor

2. In Query Editor, right-click and then select Trace Query in SQL Server Profiler:

right-click sql server profiler

Start SQL Server Profiler from Activity Monitor

1. In the Object Explorer, right-click an instance of SQL Server, and click Activity Monitor:

select activity monitor

2. In the “Processes” tab, right-click on any process you want to trace and Select the “Trace Process in SQL Server Profiler” option:

trace process sql server profiler

 

This concludes Start SQL Server Provider in Management Studio.

Looking for quality Windows Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , , , , , , , , , , , , , , , , | Posted under DotNet/Windows Hosting, DotNetPanel Administration, WebsitePanel Tutorials | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

2 Comments on Start SQL Server Provider in Management Studio

  1. John says:

    Typo in your blog: Change title from
    Start SQL Server Provider in Management Studio to
    Start SQL Server Profiler in Management Studio

    Cheers!

Leave a Reply

Your email address will not be published. Required fields are marked *