Chapter 6. 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? ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial