Chatta subito con l'assistenza
Chat con il supporto

Foglight for Sybase 5.7.5.40 - User and Reference Guide

Using Foglight for Sybase
Exploring the Sybase Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference About us

Workload Summary Extended Report

Previous Next


Using Foglight for Sybase > Generating SybaseMDA Reports > Workload Summary Extended Report

Workload Summary Extended Report

The Workload Summary Extended report provides detailed information about all major aspects of your monitored environment. It contains the following sections:

Instance Information shows the information about the selected database server, such as its health, user connections, engine, cache, databases running, and others.
Last Alarms lists the alarms generated against the monitored system, and for each alarm, shows the time it was created, its duration, source name, and the alarm message.
Important Metrics Statistics Summary lists various metrics, grouped into several collections, such as Engines, Processes, SQLs. For each metric, it gives its value before the change and after the change, along with the baseline value for the period after the change. It can help understand the impact of one metric change on another. For example, a dramatic decrease in cache misses can be caused by an increased use of APF reads.
System Wait Classes shows in graph form the amount of time spent on various system processes, such as system events, disk writes, and others, for the system wait classes, during a selected time period.
Engine Activity Summary indicates the number of Sybase engines and connections. It also shows in graph form the average percentage of times the engine, engine I/O and engine CPU were busy over a selected time range.
Engines Details lists all Sybase engines and shows the average percentage of times each engine was busy, including I/O and CPU busy times, among other metrics.
Engine and Processes Summary contains several graphs, showing the average percentage of busy engine I/O and CPU times, and the counts of active and blocked processes, over a selected time range.
Locks Details lists various metrics, grouped into several collections, such as Connections, Locks (Max), Locks (Average), Locks (Total), and Deadlocks. For each metric, it gives its average values.
Blocked Tree lists information on blocked trees, for each entry, shows the SPID. login name, database name, application, locked table, SQL text, and other metrics.
Cache Activity Summary shows the number of named data caches, their total size, the size of the procedure cache size, the maximum available memory, the available physical memory, and the data and procedure cache hit rates.
Cache Graphs Summary contains graphs that indicate the data cache hit rate average, hits, misses and dirty buffers, as well as the procedure cache hit rate average, requests, loads, and writes.
Data Cache Details show the metrics for each named cache, such as the size in MB, average hit rate, and others.
Data Pools Details show the various metrics for each named cache, such as the I/O size, pool size, and others.
I/O Activity Summary shows the numbers of I/O devices and database, and various I/O read and write rates. It also lists various metrics, grouped into several collections, such as I/O and Pages. For each metric, it gives its average values, the expected range, and the deviation (if applicable).
I/O Waits Summary shows in graph form the amount of time spent on disk write and read waits over a selected time range. It also lists class-related events and shows wait-related metrics for each event. There are two wait classes that appear in this section: Disk Read Wait with the class ID of 2, and Disk Write Wait, with the class ID of 3.
Device I/O Summary shows in graph form the rate of device reads, writes, and Asynchronous Prefetch Activity (APF) reads, and then the same information in comparison with the expected baseline.
Device I/O Details lists all I/O devices, and for each device it shows its logical name, physical name, total I/O amount, the counts and averages of the device writes, reads, and APF reads, and other metrics.
Temporary Database Spaces Usage shows the space usage for temporary databases, including the total amount of database space, and the available space. The same information appears in graph form, for a given time range.
Network Activity Summary shows the average numbers of bytes received and sent per data packet, and their rate. The rates also appear in graph form for a selected time range.
Network Waits Summary shows in graph form the amount of time spent on network input and output waits over a selected time range. It also lists class-related events and shows wait-related metrics for each event.
Network I/O Details lists various metrics, grouped into several collections, such as Packets Received and Packets Sent. For each metric, it gives its average values, the expected range, and the deviation (if applicable).
Top SQL provides detailed information about the SQL statements that experienced the longest duration or highest number of total wait events during the specified time range. The Top SQL information is sorted by the Avg Duration (ms) column.
Top Procedure provides detailed information about the specific SQL procedure that experienced the longest duration or highest number of total wait events during the specified time range. The Top Procedure information is sorted by the Avg Duration (ms) column.

This report template provides the Max Rows input parameter, which allows you to specify the number of rows to be shown in each SQL table.

 

Reference

Previous Next



Reference

This section contains reference information about views, rules, and data tables that are included with the cartridge. Read this section to find out details about these components.

Views

Previous Next


Reference > Views

Views

Foglight displays monitoring data in views that group, format, and display data. The main types are described below.

Dashboards are top-level views that contain lower-level views. The dashboards supplied with Foglight, as well as those created by users, are accessible from the navigation panel.

Lower-level views in Foglight can be added to dashboards or can be accessed by drilling down from a dashboard. They receive and display data directly from the Foglight Management Server or from other views. Some views filter or select data that appears in other views in the same dashboard. Some are tree views with expandable nodes for selecting servers, applications, or data.

This cartridge includes the following views:

 

About us

Previous Next



About us

We are more than just a name

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation™.

Our brand, our vision. Together.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.

Contacting Quest

For sales or other inquiries, visit https://www.quest.com/company/contact-us.aspx or call +1-949-754-8000.

Technical support resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione