Foglight for SQL Server (Cartridge) 7.3.0

Viewing the Databases Dashboard


	NOTE: The following section describes the various components of the Databases dashboard. To learn how to customize this dashboard’s display and focus on a requested instance, see Selecting an Instance to Monitor .

The Instance home page is opened by accessing the Databases dashboard.

To access the Databases dashboard:

Ensure that the navigation panel on the left is open.

To open the navigation panel, click the right-facing arrow

on the left.

On the navigation panel, click Homes > Databases.

The Databases dashboard provides an at-a-glance view of the monitored environment, with all the currently monitored database types.

The Databases dashboard includes these sections:

•

Database cartridge type tiles — each tile represents a database type (SQL Server, SQL Server BI, Oracle, Sybase, DB2, MongoDB, Cassandra, or All Instances). Tiles display the number of instances for each database type, along with a breakdown according to the instance health (Normal, Warning, Critical, Fatal, or Unknown).

•

Status section — includes the following components:

•

Status summary — a color-coded bar, which provides a visual representation of the summarized health condition of all instances listed in the Database Group table.

The status summary bar provides a graphic representation of the monitored environment’s current state, broken down to the number of instances and their current health state: Fatal, Critical, Warning, Normal or Unknown.

•

Database-specific health summary — when the database group All is selected, this section displays all the currently monitored instances for each database type, divided by their health state (for example: four SQL Server instances, three of which have the health state Warning and one is indicated with the health state Fatal). When a user-defined database group is selected, this section displays data only about the agents included within the selected group.


	NOTE: The Status Indicators section can be used for filtering the Databases Group table to display only instances that meet a criterion set in this section. For details, see Filtering the Display by Severity .

•

The Monitor button — Use this button to add instances to monitor. For details, see Monitoring Data Replication .

•

The Configure Alarms button — Takes you directly to the Administration > Alarms page. On the Alarms page you can view the alarms as well as configure the Alarm Template and alarm notification settings.

•

The Settings button — Use this button to do one of the following:

•

Access the User Management settings, allowing you to restrict which instances specific users are allowed to view. This makes it easier to for users to find information about only the instances they are interested in. For details, see Assigning Instances to Users or Groups .

•

After selecting one or more instances of the same database type, use this button to set options for collecting, storing, and displaying data for the selected instances, and configuring the connection to SQL Performance Investigator (if installed). For details, see Viewing User-Defined Collections .

•

Currently selected database group table — a list of all monitored databases within the database group that is selected in the Databases section. For details, see Currently Selected Database Group .

•

The Select dashboards (

) button — provides direct link to several drilldowns and panels, by that means saving the need to navigate to these locations through the Overview drilldown.

Assigning Instances to Users or Groups

The User Level Access screen allows you to assign specific instances to users or groups. When users view their Databases dashboard, they only see the instances assigned to them.


	NOTE: The Status Indicators section filters the Databases Group table to display only instances that meet a criterion set in this section. For details, see Filtering the Display by Severity .

The User Level Access screen displays all users and groups as they appear in the Foglight User & Security dashboard. By default each user is assigned to view All instances monitored in the Foglight Management Server.

To assign instances to a specific user or group:

On the main Database dashboard, click Settings and select User Level Access from the menu.

The Users and Groups panes appear.

To assign instances to a specific user or group, locate the user name in the table. Click the relevant value under the required domain in the Assigned instances column. You can also click Configure in the right column.

Select one of the 3 options:

•

Manage — allows you to manage which instances or groups to view

•

All Instances — set the user to view All monitored instances

•

None — block the user from viewing any monitored instances

Select Manage the instances to display the Assign Instances view.

Select the instances or the pre-defined groups of instances.

Click the arrow button to move the instances from the Assigned Instances box to the Available instances box.

Click Set save your choices and exit.


	NOTE: A Reset button is available in the Users table toolbar. This button allows you to reset user level access to the default behavior. All users will be assigned to view all instances.

Selecting an Instance to Monitor

Because the Databases dashboard displays by default all the currently monitored databases, customize the dashboard’s view to display only the relevant instances, and then preview such instances to decide which to monitor.

To select an instance to monitor:

Display only instances relevant for your needs, using one of the following methods:

•

Filter by database type — if multiple database types are being monitored, click the database type tile that represents the requested type (in this case, SQL Server).

•

Filter by severity — use the status indicators to display only instances of a specific database type that share a specific health state severity. For further details, see Filtering the Display by Severity .

•

Create user-defined groups — use the Databases area to create groups that contain only the databases that need to be monitored for a specific need. For further details, see Creating Custom Database Groups .

•

Assign Instances to specific users — When accessing a Database dashboard, non-administrative users view only instances which have been assigned to them. For details, see Assigning Instances to Users or Groups .

View the selected instances’ severity level, using the status indicators.

Click the requested instance to view a cue card with a preview of the instance’s most significant performance indicators. For details, see Previewing the Requested Instance .

Click Home Page on the cue card to open a full-screen view of the requested instance.


	IMPORTANT: Launching a full-screen view of the requested database by clicking the Home Page link can be carried out only for instances monitored in Foglight for SQL Server mode.

Currently Selected Database Group

This Databases table displays the group that is selected from the available database groups under the Databases section of the navigation pane.

The Databases table contains the following columns:


	NOTE: Because the currently selected group can contain instances of types of database monitored by Foglight, the table describes instances in general.

Table 2. Databases Table

The instance’s highest severity alarm, which determines the instance’s health state.

Name

The name of the instance.

Version

The version number of the instance.

Up Since

The date and time when the instance was last restarted.