Microsoft® SQL Server 2008 R2 Unleashed

Profiler Usage Scenarios

This chapter has already covered many of the technical aspects of SQL Profiler, but what about some practical applications? Beyond the obvious uses of identifying what SQL statements an application is submitting, the following sections look at a few scenarios in which the SQL Profiler can be useful. These scenarios are presented to give you some ideas about how SQL Profiler can be used. You’ll see that the monitoring and analysis capabilities of SQL Profiler are limited only by your creativity and ingenuity.