AnsweredAssumed Answered

Monitor SQL queries based on processing time

Question asked by Senyam on Feb 17, 2011
Latest reply on Feb 22, 2011 by Hiko_Davis

We are trying to find SQL's which are taking more than 30 seconds in order to correlate app & DB response times for critical transactions.
Currently SQL agent is showing all SQL's with restriction of 990 characters length.
We would like to extend the SQL length to show entire SQL string (only SQL's running more than 30 seconds).
Is there any way we can monitor only SQL's with >x seconds and increase the maxlength to show entire string.
Appreciate ur help.