Using Idera to investigate a problem during specific time

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.

Idera_Perf_0

3. Check for SQL Queries for performance analysis
Sessions -> Details -> Analyze and Export to Excel.

Idera_Perf_1

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.

Idera_Perf_2

Advertisements
This entry was posted in SQL, SQL Server, Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s