SQL Server – Steps to create the Profiler Trace

With the help of this post sharing with you the steps to create the Profiler Trace. Open the SQL Server Management Studio >> Go to Tools >> SQL Server Profiler It is mandatory for the user to have system admin rights to start the profiler. Once the profiler is started click on Menu >> File >> New Trace Below screen display for Trace Properties Here we are using the trace with default standard template for demo. You can choose as

» Read more

SQL Server – Profiler Trace Vs Server Side Trace

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

» Read more