I am trying to see the performance of my application< and i wanted to test how long the execution of stored procedures and the sql queries taking . And also i wanted to check the locks at the same.So while starting my tracing file what are the options i should select .
Thanks.