Tchater maintenant avec le support
Tchattez avec un ingénieur du support

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

Defining Data Collection and Storage Options

Foglight for SQL Azure’s agent collects and stores data at all times, even when the browser window that displays the data is not active. Use the Collection Frequencies administration screen to specify:
•
Which collections are sampled and stored.
•
The data collection values when sampling is carried out in offline, online, and real-time frequency modes.
•
The collection frequency.
When a user is currently focusing on a screen, the sampling frequency for all of the collections associated with this screen switches to Real-Time. The collection frequency determines the sampling frequencies of the other collections (that is, collections that are not running in Real-Time mode).
The available collection frequencies are as follows:
•
Low—all collections are running in Offline mode, regardless of whether a Client is connected
•
Normal—the collections' running mode (Online/Offline/Real-time) adjusts dynamically to the Client's connection status (disconnected/connected/focusing on a screen).
•
High—all collections are running in Online mode, regardless of whether a Client is connected.
•
The Query timeout for on-demand collections.
This setting defines the number of seconds that a query for on-demand collections can run before it times out.
On-demand collections are collections whose data is retrieved not by predefined time intervals but upon entering a screen or clicking a button.
The default setting of this parameter is 60 seconds, but it can be modified by clicking the number that indicates the parameter’s value in the field Query timeout for on-demand collections:.
 
 
Table 1. The Collections table
Column
Description
Collection Enabled
Indicates whether the selected collections are sampled and stored.
Collection Name
The name of the collection. This list is sorted in an alphabetical order.
Offline Frequency (Sec)
Allows defining the collection interval, in seconds, in offline mode (for example: 300).
Offline frequency refers to the longest interval possible for sampling the monitored instance.
Online Frequency (Sec)
Allows defining the collection interval, in seconds, in online mode (for example: 60).
Real-time Frequency (Sec)
Allows defining the collection interval, in seconds, in real-time mode (for example: 20).
Only one collection can be sampled at real-time frequency in any given moment.
Query Timeout (Sec)
The amount of time, in seconds, that elapses before the query times out.
 
To modify the values of a specific collection:
1
Select the collection’s row in the table.
2
Click Edit.
Figure 5. The Edit the Collection dialog box appears.
3
Select whether to enable the collection and storage of the selected collection.
4
Set the collection interval, in seconds, in offline frequency mode (if available).
5
Set the collection interval, in seconds, in online frequency mode (if available).
6
Set the collection interval, in seconds, in real-time frequency mode.
7
Set the query timeout, in seconds.
8
Click Set to apply these settings or Cancel to reject them.
9
If no more editing is necessary, save the changes before switching to another screen. For details, see Reviewing the Global Administration Settings on page 56.

Configuring User-defined Collections

The User-defined Collections global administration screen allows adding user-defined collections to all of the currently selected agents, to provide for queries not included in Foglight for SQL Azure.
After collections are added, this screen displays all of the user-defined collections for all of the agents; for example, if a collection was added to 12 agents during its addition, the screen will display 12 rows, showing the collection for each agent.
 
* 
IMPORTANT: While editing can be carried out only after selecting a specific agent’s row, clicking Add allows adding user-defined collections for all agents enabled for such collections, as well as enabling agents for user-defined collections.
This screen can also be used for configuring the sampling frequency for each collection.
The available sampling frequencies are as follows:
•
Real-Time - When a user is currently focusing on a screen, the sampling frequency for all of the collections associated with this screen switches to Real-Time.
•
Online - When at least one user is connected, the sampling frequency for all of the collections that are not currently running at Real-Time frequency switches to Online.
•
Offline - When no user is currently connected to the application
To add user-defined collections:
1
Click Add.
The User-defined Collections screen appears.
One of the following dialog boxes appear:
•
If all agents are enabled for user-defined collections, the Add a User-defined Collection dialog box appears. Proceed to Step 7.
•
If one or more of the selected agents is not enabled for user-defined collections, the User-defined Collections Not Enabled dialog box appears. Proceed to Step 2.
2
Select the requested database agents. Alternatively, to select all databases running under a specific instance, select the instance itself.
3
Click Edit credentials.
Figure 6. The dialog box Edit Credentials for User-defined Collections appears.
4
Use this dialog box to specify which credentials are to be used for enabling user-defined collections for this agent:
•
Current agent credentials - the credentials that were defined during the creation of the agent and are currently used for monitoring the SQL Azure instance or database.
•
Dedicated credentials - user-specified credentials, to be used exclusively for user-defined collections.
 
* 
IMPORTANT: For security purposes, it is advisable to enter dedicated credentials with the minimum privileges required for running the user-defined collection (SQL query).
5
Click OK.
The Applying Modified Setting progress bar appears.
Upon successful completion of the setting modification process, the notification Credentials have been set on the selected agents is displayed.
6
Click OK.
7
Type a name in the Collection Name field.
8
Enter a brief description of the collection in the Collection description field (optional).
9
Paste the query’s SQL text in the Query Text field.
 
* 
NOTE: This field can hold up to 4096 characters.
10
Type a value, in seconds, in the SQL Query Timeout field.
11
Click Verify.
The collection is verified by running the query on each of the currently selected agents.
After the verification process is complete, the Verification Results pop-up appears, indicating whether the collection was verified successfully. In case the collection verification failed, the error message is displayed.
If the verification succeeded on at least one agent, the collection’s details are displayed on the table detailed below.
 
Table 2. Collection Details
Section
Field
Description
Database
ID
The collection’s ID.
Column Name
The name of the database column.
Column Type
The field type, as retrieved by the query (string, integer, and so on).
Data Storage
Display Name
The column’s display name.
 
Type
The topology type for storage purposes. This type can be one of the following:
•
String
•
Integer
•
Double
•
Boolean
•
Date
NOTE: When the Frequently modified check box is selected (the default state), the field’s change history is kept, including use of optional functionalities such as use of the IntelliProfile mechanism and aggregation type selection. Clearing this check box is recommended only for fields whose values change infrequently, such as IP address of a specific host, as storing the change history of such fields is highly CPU intensive and may degrade the FMS performance.
 
Unit of Measurement
The metric’s unit of measurement.
The possible measurement unit values are: Percent, Count, Millisecond, Second, Minute, Hour, Day, Byte, Kilobyte, Megabyte and Gigabyte.
 
Aggregation
Allows defining the value that is displayed in this metric, out of several values that were returned in the relevant time range.
The available aggregation values are:
•
As is—value of the last sample taken during the selected time range
•
Sum—summarized value of all samples taken during the selected time range
•
Average—average value of all samples taken during the selected time range
 
Is Key
Indicates whether the field is the query’s key for retrieval.
NOTE: Fields that are indicated as keys should correspond with the database result set unique values. Selecting a field which has frequently changing and repeating results as key is allowed, but may result in unexpected behavior from the defined collection.
 
Configured to use IntelliProfile
Indicates whether this property has a baseline value.
 
Except for the Column Name and Column Type fields, whose values are retrieved by the query and cannot be changed, all other fields can be edited by clicking any of them.
Figure 7. The Edit Collection Properties dialog box appears.
 
This dialog box allows editing the values of the following parameters:
 
Table 3.  
Property Name
Availability for Editing
Display name
Always
Is Key
Always
Type
Always
IMPORTANT: The following properties can be edited only if the Frequently modified check box is selected. In addition, each property has at least one other availability criterion, as listed below.
Unit of Measurement
Available for all property types except String
Aggregation
Available for all property types except String
Configured to use IntelliProfile
Available when:
•
The property type is not String
•
The aggregation method used is Average of Sum
 
In addition, the collection’s sampling frequencies are displayed on the table at the bottom of the screen, and can be edited by clicking any of them.
12
Ensure that all settings are appropriate, and click OK to finish the collection creation process.
The newly created collection now appears on the table.
 
* 
IMPORTANT: After adding the requested user-defined collections, the only modifications possible are changing the collection frequencies and descriptions (see Editing user-defined collections on page 64); otherwise, collections can only be deleted or cloned to other agents. If one or more queries need to be modified, delete them and create new ones.

Editing user-defined collections

To edit the collection frequencies description of a specific collection:
1
Select the requested collection’s row.
2
Click Edit.
The Edit a User-defined Collection dialog box appears.
 
* 
IMPORTANT: It is advisable to review the collection’s properties that cannot be edited, to decide whether to change only the description and frequency or delete the collection and create a new one.
3
Click any of the values on the collection frequencies (lower) table.
Figure 8. The Edit Frequencies for the Collection dialog box appears.
4
Change the requested parameters.
5
Click Set.

Configuring the On-demand Data Port

The On-demand Data Port global administration screen allows defining a port for each Foglight Agent Manager (FglAM) to be used for retrieving data and integrating with StealthCollect.
By default, the collection of on-demand data is carried out via the same port used for connecting to the Performance Analysis middleware. Use this screen to collect on-demand data via a different port, or if another port was allocated to the Performance Analysis middleware.
To configure a port for the collection of on-demand data:
1
Select the check box near the names of the requested Foglight Agent Managers.
2
Click Set port.
The Set On-demand Data Port dialog box appears.
3
Type the number of the requested port.
4
Click Set.
5
Click Validate connectivity.
The Validate connectivity progress bar appears. At the end of the validation process, the connection status appears on the Status column.
If the connection failed, take the requested correction measures and try again.
 
* 
IMPORTANT: Changes to the On-demand Data Port screen take effect immediately and do not need to be saved.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation