What Is Sql Profiler?

1.	What Is Sql Profiler?
Answer» Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or ANALYSIS Services. You can capture and save data about each event to a file or table to analyze later. 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.

Answer»

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or ANALYSIS Services. You can capture and save data about each event to a file or table to analyze later.
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.

Discussion