Profiler Usage Scenarios

This chapter has already covered many of the technical aspects of SQL Server 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 Server Profiler can be useful. These scenarios are presented to give you some ideas about how SQL Server Profiler can be used. You’ll see that the monitoring and analysis capabilities of SQL Server Profiler are limited only by your creativity and ingenuity.

Get Microsoft SQL Server 2014 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.