Versions Compared

Old Version 8

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 9

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Server tree SERVERS sidebar contains all the SQL Server instances for the selected view, and allows you to drill down to the specific SQL Server components. Selecting these components opens corresponding views, providing detailed information.

The Server tree also displays tags, which are a way of labeling and organizing servers.The tree shows the defined tags and highlights when servers within the tag are in an alert state. Select a tag to show a filtered view of the servers within that tag.

...

that are monitored by SQL Diagnostic Manager, providing a general overview:

Image Added

  • The SERVERS panel includes a search bar that eases the search in environments with a large number of instances.
  • Under MY VIEWS, select All Servers to see all your instances thumbnails with fast information, review more about the available views. Additionally, MY VIEWS displays status icons, when a SQL Server instance is associated with a Critical, Warning, OK, and Maintenance Mode metric icon, you can use your mouse cursor to hover over the server name to view the top three associated alerts

...

  • , allowing you to prioritize your

...

  • SQL Server instances and the work that you need to perform.
  • The Servers sidebar displays tags, which are a way of labeling and organizing servers.
  • Under Servers, you can find the list of the monitored servers by SQL Diagnostic Manager, click any of your servers name to access the Overview screen of the selected server.

The Servers sidebar can be expanded or collapsed, allowing you to have a larger screen space.

Image Added

Additionally, SQL Diagnostic Manager allows you to undock and move your panels as you prefer. Double-click the dark gray bar to undock the panel, move it wherever you preferred, and double-click to return to its original location:

Image Added

A full refresh of alerts excluding table fragmentation occurs in the following circumstances even if longer collection intervals are defined:

  • When the collection service starts
  • When the collection service receives a new workload, such as redirecting the Management Service to a new Repository
  • When you add a SQL Server SQL Server for collection
  • When a SQL Server SQL Server resumes from Maintenance Mode
  • When a user selects Refresh Alerts

...

When you select a SQL Server SQL Server instance in the Server treeServers sidebar, the Overview tab opens.The Overview tab contains displays the following options:

 The Dashboard view is where you can see a graphical representation of the most important metrics for the selected SQL Server SQL Server instance.

 The Details view lets you view the values of each data item collected and create charts with the specific data items you need.

 The Configuration view allows you to view and control the operational configuration of the monitored SQL Server instance.

 The Active Alerts view   allows you to view and control the active alerts as of the most recent data collection.

 The Timeline view allows you to view all alerts and maintenance mode events as well as the first monitored event for the selected SQL Server SQL Server instance.

...

By right-clicking a SQL Server SQL Server instance in the Servers tree sidebar you can perform the following actions:

 Opens the Dashboard view for the selected monitored SQL Server SQL Server instance.

 Gathers the alert status and refreshes the tree view information for the selected monitored SQL Server SQL Server instance.

 Allows you to delete the SQL Server SQL Server instance from your SQL Diagnostic Manager installation. When you select Delete, SQL Diagnostic Manager displays a message asking whether you want to retain the collected data for the SQL Server SQL Server instance, and it also allows you to cancel out of the deletion process.

Tip

You cannot retrieve collected data once it is deleted from the SQL Diagnostic Manager Repository. Use the Delete option with care.

 Allows you to take an individually monitored SQL Server SQL Server instance offline for scheduled maintenance or other reasons.

 Allows you to configure the performance baseline for the selected SQL Server SQL Server instance.

 Allows you to select an existing alert template to apply to the selected SQL Server SQL Server instance.

 Allows you to specify the alert criteria for each collected metric on the selected SQL Server SQL Server instance.

 Allows you to snooze all the alerts for the selected SQL Server SQL Server instance instead of selecting the snooze feature for each alert individually.

 Allows you to resume any alerts set to snooze on the selected SQL Server SQL Server instance.

 Allows you to view and edit the collection properties of your SQL Server instance.

...

Scroll pdf ignore