What is SQL Server Profiler?

The SQL Server Profiler, one of SQLServer’s most powerful auditing and analysis tools. The SQLServer Profiler gives you a basic understanding of database access and helps you answer questions such as these:

• Which queries are causing table scans on my invoice history table?.
• Am I experiencing deadlocks, and, if so, why?.
• What SQL queries is each application submitting?.
• Which were the 10 worst-performing queries last week?.
• If I implement this alternative indexing scheme, how will it affect my batch operations?

SQL Server Profiler records activity that occurs on a SQL Server instance. The tool has a great deal of flexibility and can be customized for your needs. You can direct SQL Server Profiler to record output to a window, file, or table.You can specify which events to trace, the information to include in the trace, how you want that information grouped, and what filters you want to apply.