JAMon Presentation
Steve Souza
Nov 2003
Page 6
lThree out of 25 stored procs accounted for 95% of application execution time.
Finding Performance Bottlenecks
Discuss first line, then code, then Sortable html report , then stats gathered.  We used this information to target our tuning efforts and tune these procs.  We used this information to improve performance of these stored procs by a factor of 4. ubstantially faster than the client server version of cors.   More data than this

More than page hits, stored procs, label appears in report
Hits, average time, total time, standard deviation, min and max times

Actual data from cors.  Explain statistics via pageHits.   We have used this information to increase the speed of the onfilefiles proc by a factor of 20.