Microsoft® SQL Server 2005 Unleashed

Chapter 5. SQL Server Profiler

IN THIS CHAPTER

• What’s New with SQL Server Profiler

• SQL Server Profiler Architecture

• Creating Traces

• Executing Traces and Working with Trace Output

• Saving and Exporting Traces

• Replaying Trace Data

• Defining Server-Side Traces

• Profiler Usage Scenarios

This chapter explores the SQL Server Profiler, one of SQL Server’s most powerful auditing and analysis tools. The SQL Server 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 ...