I want to see what query is ran the most in a given day so I know which ones are most important to optimize. I would prefer to do this without downloading any patches or installing third party software. The query profiler will let you see all of the queries that have been ran but it does not sum up one single query. You would have to go through by hand and count each instance. So if there is anyone out there who has had this problem let me know.
Hey I just thought of a solution. What if I guessed which queries were ran alot and then went and put triggers on those queries. The triggers would increment a count for that query in a, uhhh… will call it a frequently run query table. Would that be a dumb idea?