Chatta subito con l'assistenza
Chat con il supporto

Foglight for SQL Azure 5.5.8.6 - User Guide

Introducing Foglight for SQL Azure Adding and Configuring Agents Reviewing SQL Azure Activity Reviewing Database Usage Reviewing the Database Properties Monitoring Estimated Costs Viewing User Metrics Using the Global Administration Options Reviewing Foglight for SQL Azure Alarms Glossary

Selecting the Database to be Monitored

As the Databases dashboard displays by default all of the currently monitored databases, it is advisable to customize the dashboard’s view to display only the relevant SQL Azure instances, and then preview thedatabases within these instances to decide which to monitor.
To select the database to be monitored:
1
Display only relevant instances, using one of the following methods:
•
Filtering by database type—if multiple database types are being monitored, click the database type tile that represents the requested type (in this case, SQL Azure).
•
Filtering by severity—using 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 on page 9.
•
Creating user-defined groups—using 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 on page 9.
2
View the selected instances’ severity level, using the status indicators.
3
Click the requested SQL Azure database to view a cue card with a preview of the database’s most significant performance indicators. For details, see Previewing the Requested Database on page 11.
4
Click Home Page on the cue card to launch a full-screen view of the requested database.
 
* 
IMPORTANT: Launching a full-screen view of the requested database by clicking the link Home Page can be carried out only for instances monitored in Foglight for SQL Azure mode.

Filtering the Display by Severity

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.
To filter the display by severity:
1
Click a a specific type of severity within a specific database type (for example: SQL Azure instances whose severity level is Fatal).
Figure 2. Selected filter is shown in the title of the table
 
2
To select another filter, click the required status indicator (for example: SQL Azure > Normal severity). To display the entire list of databases, click Clear filters.

Creating Custom Database Groups

While all existing and newly discovered instances are added to the All list, the Databases area of the navigation pane allows creating, editing, and removing sub-groups of database instances, thereby serving as a filter that allows displaying only a specific, user-defined group of instances.
 
* 
IMPORTANT: Custom database groups can be created in SQL Azure only by grouping instances.
The Databases area includes the following components, which can be selected from a drop-down list:
•
Database Groups—includes by default the All list, as well as the Database Groups list, which serves as the parent group for creating user-defined sub-groups of database instances. Such sub-groups are recognized as Foglight services.
The Database Groups section also displays the highest severity level of the database groups, under the column Sev.
•
Services—displays the configured services, which contain at least one object (database topology) that is used by Foglight for SQL Azure.
All of the Foglight for SQL Azure sub-groups, which were created via the Database Groups section, are displayed also under Services. In addition, Services displays groupings of monitored resources that were created via the Service Builder dashboard, and contain Foglight for SQL Azure database topology.
The Services section also contains the column SLC (Service Level Compliance), which indicates the current availability of the selected service over a given period of time.
For details about the Service Builder dashboard, see Foglight Online Help.
To create a database group:
1
Select the parent database instance group, Database Groups, under Databases in the navigation pane.
Figure 3. Parent database group selected under Databases
2
Click the button.
Figure 4. The Add Sub Group dialog box appears.
3
Type a name for the group in the Name field.
4
Type a description for the group (optional).
5
Select an instance in the Available column, and click [>] to move the instance to the Selected column.
Alternatively, click [>>] to move all of the databases to the Selected column.
6
Click OK.
The sub-group name appears in the Database Groups list.
Figure 5. The database instances are listed in the Databases dashboard.
After adding one or more user-defined sub-groups, it is possible to add sub-groups to these sub-groups.
 
To remove a database sub-group:
1
Select the sub group to be removed.
2
Click the button.
The verification dialog box appears.
 
3
Click Remove.
The sub-group is removed from the Database Groups list.
To edit a database sub-group:
1
Select the requested sub group.
2
Click the button.
Figure 6. The Edit Group dialog box appears.
3
To add an instance to the sub group, select the requested instance in the Available column and click [>].
The selected instance moves to the Selected column.
4
To remove an instance from the sub-group, select the requested instance in the Selected column, and click [<].
The selected instance moves to the Available column.
5
Click OK.

Previewing the Requested Database

Clicking a database in the databases group table opens the quick view panel, which serves as a cue card for the selected instance, providing all of the principal data at a glance.
 
* 
NOTE: To directly access the home page of instances monitored in Foglight for SQL Azure mode, click the Home Page icon to the right of the instance name.
Figure 7. Quick View Panel
The quick view provides a preview of the database’s most significant indicators, via the following sections:
•
General—identical to the home page’s Instance pane.
This section provides the following details:
•
DB Type—identifies whether the monitored database’s type is SQL Server, SQL Azure, Sybase, DB2 or Oracle.
•
Version—identifies the database version number, along with the most recently installed service packs.
•
Up Since—identifies the date and time when the instance was last started.
•
Alarms—displays the number of warning, critical, and fatal alarms for the instance.
The alarms are displayed by their severity levels, with the aggregated number for each severity.
 
* 
IMPORTANT: Only several alarm types are invoked for instances monitored using the SQL Azure. For details, see Reviewing Foglight for SQL Azure Alarms on page 73.
•
Performance—displays the total number of active sessions, compared with the total number of sessions.
•
Configuration—displays different data in Database and Instance views:
•
In database view—indicates the database edition type; either Business or Web
•
In instance view—displays the number of databases of each edition type
•
Activity—a bar displaying the average number of active sessions for the SQL Azure instance during the specified time range.
•
Availability—displays the following indicators of the database or instance availability:
•
Availability—average availability over the specified time range.
 
* 
IMPORTANT: While a database can be either available or unavailable—namely, have an availability value of 100% or 0%—an instance’s availability value can vary throughout the entire range, depending on the number of databases available at each given moment.
•
Response Time—average response time over the specified time range.
Response time is the full time (in milliseconds) it has taken a query (by default: select 1) to get from the application to SQL Azure and back.
Every time a real-time sampling interval starts (by default: 5 minutes), a query is sent and its response time value is displayed. Any value higher than 200 ms may indicate a performance issue.
•
Data flow area—displays the following indicators about data flowing in and out of the SQL Azure instance or database:
•
Bandwidth incoming—the average rate of incoming data (MB/Sec)
•
Bandwidth outgoing—the average rate of outgoing data (MB/Sec)
•
Storage—displays the following data about the monitored entity’s space utilization, either monitored or non-monitored:
•
Total—the total size of the entity’s space
•
Reserved Size—the space reserved for use by the database or instance
•
Free size—the space that is currently not in use
•
Workload (Avg. Active Sessions)—a chart displaying the workload for the SQL Azure instance, plotted over the specified time range
The Workload section also contains the Home Page button, which allows accessing the Foglight for SQL Azure home page.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione