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.
You can use SQL Profiler to monitor only the events in which you are interested.
For example, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.
Asked In: Many Interviews |