Profiler capturing certain events for performance tuning

  • I read that a typical trace to tune the SQL Server's performance is to include SQL:BatchCompleted and RPC:Completed events. Is this true that these are the only two event classes that need to be captured by the profiler for basic tuning?

    Wouldn't SQL:BatchCompleted have every event that RPC:Completed would have? I read the definitions on Microsoft's website. My guess is that SQL:BatchCompleted has SQL commands without parameters. RPC:Completed includes SQL commands with parameters exclusively.

    Please confirm my understanding that SQL:BatchCompleted would capture the following events if they were executed: SQL Server Agent jobs, triggers and views.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply