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.