5. Real-Time and Historical Performance Analysis

Easily switch between real-time and historical modes to view performance metrics for any point in time. Use the Console toolbar to go back days or even months to see exactly how your SQL Server performance has changed over time.

To switch to Historical Mode on the Performance Dashboard, click on the History button on the toolbar at the top of the screen. The History view defaults to a 10 minute history that will continue to update. Use the Start and End time selectors, Zoom buttons, and Interval selectors to jump to any point in time at any range to explore server history.

You can also highlight any time slice within any chart, and the dashboard will synchronize all charts and enable you to zoom into a time slice, or jump to another section of Performance Advisor or Event Manager for the selected date range. For example, you can jump directly to the Event Manager calendar or the Top SQL tab to see exactly which events occurred during a spike in CPU activity.