Summary
SQL Trace is an extremely powerful tool for the SQL Server DBA and database developer, enabling a wide variety of monitoring, debugging, and auditing scenarios. In this chapter, we explored the internals of SQL Trace and the SQL Server Profiler user interface tool, as well as the security requirements for using them. Basic trace configuration using both Profiler and server-side traces was covered next. We then showed you how to use traces to solve various problems, and gave you some guidance on how to make sure that your tracing activities are as successful as possible. Finally, we discussed some of the traces that are shipped with SQL Server.
Properly harnessing what SQL Trace has to offer will make you a better, more effective DBA, ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 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.
