SQL Server Profiler is a client tool to create and execute traces. Trace is a set of events of certain types that the DBA, developer and any other role is interested in. Through SQL Server Profiler, traces could be seen in the form of live data or saved to files or database tables.
Even though SQL Server Profiler was announced as a deprecated tool (Extended Events should be a successor to SQL Profiler), there is no replacement to open, view, and correlate traced events with performance monitor data.
SQL Profiler could be opened from Management Studio, the Tools menu, option--SQL Server Profiler. When SQL Server Profiler is opened from Management Studio, the login dialog appears directly.
The second option to access SQL ...
