IN THIS CHAPTER
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 ...