Performance Optimization: Smart SQL Profiling

By Nadeem Akhter Problem Recently I had a chance to work on a system, which literally had millions of calls to the database. I wanted to know which queries were being called most frequently and which ones were taking most of the CPU cycles. I tried using SQL profiler but it made the situation worse due to its own overhead. I needed to figure out how to do this without further taxing the system. Another issue I uncovered was every time I wanted to profile something I had to go through the same manual process over and over again...

Read More