Page History

All the information displayed in the SWA Home tab is measured in seconds.

The left column displays a list of the monitored instances, allowing you to identify their status using specific icons for each possible status. Below is a description of each status:

...

STATUS

Image Modified	Instance is active and there is data collected in the last 2 minutes
Image Modified	Instance is inactive or unreachable
Image Modified	Instance has been removed
Image Modified	Unknown. No data collected in the last 2 minutes
Image Modified	Stopped

You can launch the SQL Diagnostic Manager Web console for instances that are also registered in SQL Diagnostic Manager by clicking the icon Image Added.

All the information displayed in the SWA Home tab is measured in seconds.

You can select Select a time frame from the available options (15 minutes, 1 hour, 4 hours, 1 day, 5 days, and 4 weeks) to retrieve the information.

From the list of monitored instances you can also launch SQLDM and view the instance status, as long as the instance is also registered in SQLDM. Click the SQLDM icon Image Removed to open the SQLDM Web Console.

SQL Workload Analysis makes SQL Server performance tuning easy.

...

located in the top right corner of the screen.

Image Added

The following time frames are available for SQL Workload Analysis to retrieve information:

• 15 minutes
• 1 hour
• 4 hours
• 1 day
• 5 days
• 4 weeks

Tip
Click the Image Added icon for help. This icon opens the SQL Workload Analysis wiki.

SQL Workload Analysis Dashboard

The SQL Workload Analysis Dashboard lists the top monitored instances. When you select one of the monitored instances, SQL WA displays the following information:

• Total in DB Highlights
• Total in DB Trending
• Top Databases
• Page Faults/sec
• Top SQL Stored Procedures
• Top SQL Statements
• Top Logins
• Top Machines
• Top Programs

Save