How To Use Server Profiler In SQL

Dec 10, 2019 4 1.4K

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web ...

In this article, we will learn how to use the Server Profiler in SQL Server.

Microsoft SQL Server Profiler is a graphical user interface for tracing, recreating, and troubleshooting problems in MS SQL Server, Microsoft’s relational database management system. We can capture and save data about each event to a table or file to analyze later.

For example, we can monitor a production environment to see which stored procedure is affecting performance.

SQL Server Profiler is used for activities such as:

  • To find the cause of the problem, stepping through problem queries.
  • Finding and diagnosing slow-running queries.
  • Capturing the series of Transact-SQL statements that lead to a problem.
  • To tune workloads, monitoring the performance of SQL Server.
  • Correlating performance counters to diagnose problems.

You can start the SQL Profiler from within SQL Server Management Studio, click on Tools menu -> SQL Server Profiler.

 

Set Trace Name and click Run.

 

Now we can trace or monitor SQL results.

 

Also, check How To Use Date Formats In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.
Read More

4 Comments

  1. espn.com/activate
    espn.com/activate on January 4, 2020 at 2:38 pm

    Wow, wonderful blog layout! How long have you been blogging for?
    you make blogging look easy. The overall look of your site is fantastic, let alone the content!

    0
    0
    Reply
  2. Hairstyles
    Hairstyles on December 17, 2019 at 4:48 pm

    I like what you guys are up also. Such clever work and reporting! Keep up the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my web site 🙂

    0
    0
    Reply
  3. Hairstyles
    Hairstyles on December 17, 2019 at 1:10 pm

    I am very happy to read this. This is the type of manual that needs to be given and not the accidental misinformation that’s at the other blogs. Appreciate your sharing this greatest doc.

    0
    0
    Reply
    1. Yasin Panwala on December 20, 2019 at 6:05 pm

      Thank You 🙂

      0
      0
      Reply

Submit a Comment

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

Subscribe

Select Categories