SQL Server – Profiler Trace Vs Server Side Trace

Varinder Sandhu SQL, SQL-Advanced, SQL-Performance, Varinder Sandhu

Profiler Trace

Profiler Trace using the standard default template supplied by SQL Server with SQL Profiler. SQL Profiler running on a client machine and it is connected to the SQL Server instance over the network.

Server Side Trace

The Script is used to create Server Side Trace. You can generate for server site trace with the help of SQL Profiler.

Difference between Profiler Trace and Server Side Trace (Profiler Trace Vs Server Side Trace)

Client-side traces dragged transaction throughput down as compare to Server Side Trace.
Profiler trace can consume a significant amount of network bandwidth. The server-side trace consumes no network bandwidth because it runs on the server.

Refer the MSDN for more information about SQL Server Trace.