I had a situation to troubleshoot a performance problem on a server which occurred a few days back. Following is quick reference on how Idera can be used to drill down details.
1. Select History Icon and select the time which needs investigation
2. First option I look for Active alerts during the impacted time.
3. Check for SQL Queries for performance analysis
Sessions -> Details -> Analyze and Export to Excel.
4. Resource consumption trend
Resources -> CPU / Memory / Disk
5. Server Waits
Server waits is critical to identify bottleneck and UI provides east options to drill down Server Waits.