Chat now with support
Chat mit Support

Foglight for Databases 5.9.5 - Administration and Configuration Guide

Administering and Configuring Foglight Extending Your Monitoring Reach with Foglight Cartridges Administering Foglight Configure Rules and Metric Calculations to Discover Bottlenecks Customizing Your Foglight Environment with Tooling

Manage Foglight Database Performance

In Foglight, retention policies define time periods during which the collected data is sampled, persisted into the database, aggregated, or purged from your system. The Object Cleanup dashboard is useful for inspecting, purging, and deleting data objects, and particularly for cleaning up objects that are no longer needed. For instance, if a set of agents is no longer required, the objects created by those agents are still visible in the browser interface. Removing these objects can have a positive impact on performance.

* 
NOTE: In previous releases, the Data Management dashboard allowed you to manage both retention policies and object cleanup. Beginning with Foglight 5.9.x, there are now two separate dashboards:
•
Retention Policies
•
Object Cleanup

Using these dashboards you can manually tune the size and performance of your environment. Tuning performance manually allows you to:

•
Control the persistence policies of the Foglight Management Server by setting retention policies and purging.
•
Set a global default, which auto-deletes objects after a specified period of time.
•
Manually inspect and adjust the amount of data that has been saved by showing all topology objects in the server and the metrics attached to them. You can then delete unneeded objects and metrics.
•
Purge objects that have been captured by the Foglight Management Server.

To access this dashboard, from the navigation panel, click Dashboards > Management Server > Servers. Then select either Object Cleanup or Retention Policies.

Another way to control the retention policies on a per-object basis is using the Manage Retention Policies dashboard. For more information, see Manage Data Retention.

In addition to the Object Cleanup and Retention Policies dashboards that allow you to inspect and tune the overall performance, the Database Overview dashboard summarizes the database activities such as data row operations, database buffer pool, and any inserts, deletes, and updates. To access this dashboard, from the navigation panel, click Dashboards > Management Server > Servers > Database Overview.

For more information, see the following topics:

•
Explore the Object Cleanup Dashboard
•
Control retention policies
•
Create custom retention policies
•
Manage data objects
•
Inspect the database size
•
Purge data objects
•
Deleting data objects
•
Explore the database activities
•
Grant permissions to explore database activities
•
Viewing persistence handler details

Monitor Server Performance

Foglight manages host data sent from agents, and evaluates rule conditions and metric calculations. It also provides browser interface access to remotely monitored servers. The browser interface includes a set of dashboards that allow you to monitor the server state and prevent potential bottlenecks.

The Performance dashboard contains at-a-glance view of Foglight diagnostics. It shows the rate of database inserts, data processing activity, JVM memory usage, server load, and other combinations of views. Certain types of metric patterns displayed on this dashboard can be useful in troubleshooting specific performance problems. For example, a sudden increase in free memory utilization is a good indicator that the amount of incoming data exceeds typical thresholds. To access this dashboard, from the navigation panel, click Dashboards > Management Server > Diagnostic > Performance.

Figure 6. The Performance dashboard.

The Management Server View dashboard is useful for examining server performance. Use it to look for root causes of server-related performance problems. To access this dashboard, from the navigation panel, click Dashboards > Management Server > Servers > Management Server View.

Figure 7. The Management Server View.

Server log files are another source of information that can help you diagnose the root cause of performance-related bottlenecks. They contain information about known events and error conditions as well as verbose or informational messages. The Log Analyzer dashboard allows you to analyze generated log files or download a selected log file to a desired location. To access this dashboard, from the navigation panel, click Dashboards > Management Server > Diagnostic > Log Analyzer.

For more information, see the following topics:

•
Restore agents after a Management Server failure
•
Explore the FMS Overview view
•
Explore the Agents view
•
Explore the Baseline Measurements view
•
Explore the Connectivity view
•
Explore the Database Overview view
•
Explore the Garbage Collector view
•
Explore the Java Virtual Machine Memory view
•
Explore the Objects - Rulette and Topology view
•
Explore the Script Invocation Time view
•
Explore the Server Load view
•
Explore the Service - Data and Message view
•
Explore the Service - Derivation and Query view
•
Explore the Service - Persistence view
•
Explore the Service - Topology and Agent Manager view
•
Explore the UI Query Time view
•
Look at server details
•
Explore server logs
•
Run the Management Server Performance Summary Report

Monitor Agent Manager Performance

Foglight uses the Agent Manager to communicate with monitored hosts. The embedded Agent Manager can be used to monitor the host on which the Management Server is installed. Your monitoring environment typically includes a number of Agent Manager instances that are installed on different hosts. You can monitor their state using the Performance Overview dashboard. For example, an unusually high number of pending messages in the queue indicates a potential performance bottleneck. To access this dashboard, from the navigation panel, click Dashboards > Management Server > Diagnostic > Agent Manager.

Figure 8. The Foglight Agent Manager Performance Overview dashboard.

For more information, see the following topics:

•
Explore the Foglight Agent Manager (FglAM) Overview view
•
Explore the Message Processing tab
•
Explore the Clock Skew tab
•
Explore the Bandwidth tab
•
Explore the Misbehaving Clients tab
•
Explore the XML Serialization tab
•
Explore the CPU Usage tab
•
Explore the Memory Usage tab
•
Explore the CDT Submission tab

Associate Service Objects with Groups and Tiers

Foglight monitors specific parts of your environment based on the concept of services. A service is a collection of monitored objects. An object group is a mechanism that assists in service creation and monitoring. It is a logical way of grouping objects that are of interest to an individual user (for example, an Oracle database administrator), or to multiple users of a system (for example, Oracle databases).

Object groups can be associated with another logical component, tiers. Each tier is a logical representation of a service component. A Foglight service can have one or more tiers. By default, Foglight organizes data into default tiers, including User, Web, Application, Database, Host, and Agent. Tiers allow you to structure services in a way that best represents your monitored environment. This type of logical structure helps you isolate performance problems associated with a specific service tier. For example, to investigate the state of the monitored hosts within the Host tier for a service, drill down on the Host tier and investigate the hosts that are related to it. For more information about services, see the Foglight User Guide.

The object groups that are needed for most service monitoring already ship with Foglight. You can create additional object groups and associate groups with tiers using the Object Groups and Tier Definitions dashboards.

To access the Object Groups dashboard, from the navigation panel, click Dashboards > Services > Object Groups.

To access the Tier Definition dashboard, from the navigation panel, click Dashboards > Services > Tier Definition.

For more information, see the following topics:

•
Create an object group
•
Create an object subgroup
•
Subscribe to an object group using a tier definition
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen