We use FR and also CF 9 Monitor to monitor the server performance. I had 2
questions
1. I noticed when you have monitoring and profiling ON, the slowest queries
(Detail) option shows stored proc call like this under SQL {call
Get_Employees(?, ?, ?, ?)} . It would be nice to know what values were
passed to stored proc. Is there anyway to enable that in CF monitoring?
2. For the same slowest queries tab, the SQL statement showed is sometimes
cut off. I dont know if its because of too much white space in code or limit
on so many characters. Any ideas on this?
Example : select something blah blah
..........................................
and (colname
after this colname everything is cutoff meaning incomplete query. I
would love to see full query.
Thanks,
<Ajas Mohammed />
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats what winners do.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.
