Page History
This section includes the following topics:
- About the Maintenance tab
- How the Maintenance tab is structured
- About examining Maintenance Tab Entities
- How the Maintenance tab can help you identify performance problems
| Anchor | ||||
|---|---|---|---|---|
|
Almost every SQL Server instance contains user applications along with SQL Server Agent activities (or other activities that the DBA runs to monitor the instance). The Maintenance tab mainly displays information on the SQL Agent activities and other SQL Server activities that are related to the DBA maintenance tasks.
The Maintenance tab enables you to provide answers to the following types of questions: "When was a specific SQL Agent job executed? What was the duration of the last run and which changes in the job led to performance degradation?"
| Anchor | ||||
|---|---|---|---|---|
|
The Maintenance tab displays information on a selected entity and its associated entities. When you open the Maintenance tab from the Dashboard tab, the selected entity is by default Instance, meaning that information is displayed on the instance level.
...
See “About Precise for SQL Server tabs” on page 22.
| Anchor | ||||
|---|---|---|---|---|
|
The Maintenance tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views.
...
Actions Displays a list of the actions to be performed by the selected DB maintenance plan.
| Anchor | ||||
|---|---|---|---|---|
|
You can identify a performance problem by doing one or more of the following:
...