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. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly. To use SQL Server Profiler, you need to understand the terms that describe the way the tool functions. Event An event is an action generated within an instance of SQL Server Database Engine. Examples of these are: Login connections, failures, and disconnections. Transact-SQL SELECT, INSERT, UPDATE, and DELETE statements. Remote procedure call (RPC) b...
~ a resource for the Microsoft SQL Server.