Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can anyone suggest a database performance analysis software?

Status
Not open for further replies.

sobeit

Programmer
Sep 11, 2000
38
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top