in a SQL Profiler?
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 is hampering performance by executing too slowly. Use SQL Profiler to: • Monitor the performance of an instance of SQL Server. • Debug Transact-SQL statements and stored procedures. • Identify slow-executing queries. • Test SQL statements and stored procedures in the development phase of a project by single-stepping through statements to confirm that the code works as expected. • Troubleshoot problems in SQL Server by capturing events on a production system and replaying them on a test system. This is useful for testing or debugging purposes and allows users to continue using the production system without interference. Audit and review activity that occurred on an instance of SQL Serv
