var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Tools for performance analysis and trending
I am in the process of evaluating different analysis and trending tools for SQL Server performance.
I am currently trying out a tool called Ignite (http://www.confio.com/).
Does anybody here have any experience with this tool?
Are there any other similar tools that you suggest I try out?
The tool should log performance counters, letting me do "real-time" drill-down analysis of performance problems giving me information about wait types and sql statements that causes problems.
The tool should also provide wait type trends so I can get an overall picture of how wait types related to I/O, memory and CPU changes over time.
I have not used Ignite but I use the following two...
Both are good...
You can check Quest's capacity management and performance management suites...
Quest SQL Server Management Tools
Also Idera's SQL Diagnostic Manager
SQL Server MVP
Thanks a lot. I'll check them out.