I have been using Window's Performance Monitor and the SQL
Server's Profiler to examine performance problem or to evaluate execution plans. Both tools can be helpful on a very simple querries (or SP).
I need tools that can point out indexes to add, most costly SPs, and I want something that's much easier to read than what I am getting from SQL Server's execution plan.
Does anyone know of any software that produces a friendly, and yet detail of what's going on when SQL executes the plan?
Thanks!
Server's Profiler to examine performance problem or to evaluate execution plans. Both tools can be helpful on a very simple querries (or SP).
I need tools that can point out indexes to add, most costly SPs, and I want something that's much easier to read than what I am getting from SQL Server's execution plan.
Does anyone know of any software that produces a friendly, and yet detail of what's going on when SQL executes the plan?
Thanks!