What is SQL Profiler?

Posted by

To view Verified answers click on the button below.

SQL Profiler is a graphical tool that allows system administrators to monitor events in an
instance of Microsoft SQL Server. You can capture and save data about each event to a file
or SQL Server table to analyze later. For example, you can monitor a production
environment to see which stored procedures are hampering performances by executing
too slowly Use SQL Profiler to monitor only the events in which you are interested.

If traces are
becoming too large, you can filter them based on the information you want, so that only a
subset of the event data is collected. Monitoring too many events adds overhead to the
server and the monitoring process and can cause the trace file or trace table to grow very
large, especially when the monitoring process takes place over a long period of time.