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...!

[381 byte] By [aashta] at [2007-12-22]

SQL Server

Site Classified