-1

In this source it is written something like this enter image description here

I want to know what is SQL Trace? Does it refer here to Traces inside SQL Profiler or this is a different tool. I try to search it but can't find any resource. Thanks

  • 3
    According to MS Docs SQL Server profiler is an interface to create and manage SQL Traces and analyze and replay trace results. – McNets Dec 25 '18 at 16:54
  • 3
    SQL Trace = Server side trace which has low impact than running the profiler GUI. See my answer dba.stackexchange.com/a/107510/8783. – Kin Shah Dec 25 '18 at 17:10
  • 1
    An easy way to descrive Microsoft SQL Server Profiler is a graphical user interface to SQL Trace . Source: Microsoft SQL Server Profiler is a graphical user interface to SQL Trace. FYI SQL Trace and SQL Server Profiler are deprecated. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated. – SqlWorldWide Dec 26 '18 at 12:29
1

In the picture below you see how SQL Trace collects Traces about events and one way to view those events is through SQL Server Profiler. So, they are phases in same process, making different task each.

Note from first link:

SQL Trace and SQL Server Profiler are deprecated. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated.

This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Use Extended Events instead.

For Extended Events, look my last link.

architecture

Sources:

https://docs.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/create-a-trace-sql-server-profiler?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/sql-server-management-objects-smo-programming-guide?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events?view=sql-server-2017

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.