>Is there a way to collect query response times regularly (as a part of maintenance and monitoring) other than using Profiler? I would like to collect the database name, query name, and time to completion.
>
>I have my doubts, but any help is always appreciated.
Check
http://forums.asp.net/t/1383808.aspxand thread #
1380782
If it's not broken, fix it until it is.
My Blog