SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...

When SQL Server Management Studio is already open, the easiest way to open SQL Profiler is to click on the Tools dropdown menu. Then select "SQL Server Profiler" from the menu.

SQL Trace, the server-side component of SQL Server 2000’s tracing system, works with the Profiler client-side viewing utility. (The functionality and naming of SQL Trace and Profiler have ...

That changed a bit with the release of 7.0: The client (which reads trace data) was renamed SQL Profiler, and the name SQL Trace was deemphasized. Now with SQL Server 2000, SQL Trace is back.

Brian Egler MCSE/MCT is a Microsoft SQL Server Course Director for Global Knowledge. He has more than 15 years' experience with SQL Server. Every year he runs the Boston Marathon for cancer research.

Users simply: 1) connect to an SQL Server instance, 2) select a database, 3) select a table, 4) optionally adjust profiling settings, 5) press a button, and 6) view the results.

These were first introduced in SQL Server 2008, but didn't really catch on until SQL Server 2008 R2. The second is SQL Server profiler, which is available to every version of SQL Server starting ...