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:
...
Instance is active and there is data collected in the last 2 minutes | |
Instance is inactive or unreachable | |
Instance has been removed | |
Unknown. No data collected in the last 2 minutes | |
Stopped |
You can launch the SQL Diagnostic Manager Web console for instances that are also registered in SQL Diagnostic Manager by clicking the icon .
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.
You can launch the SQLDM Web console for instances that are also registered in SQLDM by clicking the SQLDM icon .
located in the top right corner of the screen.
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 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 The dashboard displays the following information:
...
...
- Using CPU
- Log Wait
- OS Wait
- Internal Wait
You can also drill-down to each of these metrics to obtain more detailed information.
...
Displays information measured in seconds about Internal Wait, Log Wait, Lock Wait, Temdb I/O Wait, OS Wait, Using CPU, I/O Wait, Network I/O Wait, Remote Wait, and CLR Wait.
...
...
Displays a list of the most frequently executed SQL statements, including queries and updates that have been performed on a specific monitored instance and/or a specific database as may be the case.
Top Logins
Provides a list of logins executed in the monitored instances. The list also defines the type of user, the total workload in the DB (measured in seconds), and the number of executions.
Top Machines
Displays a list of client machine instances that frequently connect to a specific monitored instance and/or a specific database as the case may be.
Top Programs
Provides a list of client application programs that most frequently connect to a specific monitored instance and/or a specific database as the case may be.
SQL Workload Analysis makes SQL Server performance tuning easy.
...