SQL Tracing Data
Hi
when i set SQL Tracing to 500 i donot get any trace data,however if i reduce it to less than 500 i get trace data with queries taking greater than 500 also why is it so...why did not those stored procedures taking greater than 500 came when i had set the duration =500
What do you suggest should be the ideal time that queries should take to execute...!

