Sql Server Profiler

Here is my preferred configuration for a template to check the speed from Sql Server traces : RPC:Completed SP:StmtCompleted SQL:BatchCompleted SQL:BatchStarting Showplan XML Here you can find a good article about it