Microsoft SQL Server Profiler

The SQL Server Profiler is a graphical user interface for monitoring an instance of the database engine or Analysis Services. Data about each event can be captured and saved to a file or table so they can be analyzed later. It can be used to monitor performance of your database and identify slow performing queries or stored procedures.