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.