Solving Performance Problems with Profiler
Whether you are trying to track user activity, troubleshoot connection problems, or optimize SQL Server, SQL Server Profiler is one of the best utilities available. Profiler enables you to trace events that occur in SQL Server. Events you can track in Profiler are similar to counters you can monitor in Performance Monitor. They are organized into groups called event classes, and you can track one or more events for any of the available event classes. The strengths of Profiler are its advanced features and extensive customization capabilities.
You can record and replay Profiler traces when you want to analyze the data—and this is one area in which Profiler excels. You can:
Use the information to find slow-running ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.
