Chapter 7. Using the SQL Server Profiler

by Chris Gallelli and Ray Rankins

IN THIS CHAPTER

  • SQL Server Profiler Architecture

  • Creating Traces

  • 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 will give you a basic understanding of the application and help you answer questions like the following:

  • Which queries are table scanning 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 ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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