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.

•	System Wait Events

•	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

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

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:

•	Sybase_MDA Agent SYBM Overview Graph View

•	Sybase_MDA Agent SYBM OverviewNetwork Table View

•	Sybase_MDA Agent SYBM ResourceOverview Graph View

•	Sybase_MDA Agent SYBM ASE Availability Graph View

•	Sybase_MDA Agent SYBM ASE Config Table View

•	Sybase_MDA Agent SYBM ASE Info Table View

•	Sybase_MDA Agent SYBM BenchmarkTimes Graph View

•	Sybase_MDA Agent SYBM DBErrorLog Table View

•	Sybase_MDA Agent SYBM DataCacheDetail Graph View

•	Sybase_MDA Agent SYBM DataCachePoolInfo Table View

•	Sybase_MDA Agent SYBM DataCachePools Graph View

•	Sybase_MDA Agent SYBM DataCacheSummary Graph View

•	Sybase_MDA Agent SYBM DbSpace Graph View

•	Sybase_MDA Agent SYBM DbSpaceSegment Graph View

•	Sybase_MDA Agent SYBM DbSpaceTransLog Graph View

•	Sybase_MDA Agent SYBM DbSpaceTrendBar Graph View

•	Sybase_MDA Agent SYBM DbSpaceTrendChart Graph View

•	Sybase_MDA Agent SYBM DbStatus Table View

•	Sybase_MDA Agent SYBM DiskIODetail Graph View

•	Sybase_MDA Agent SYBM DiskIOSemaphores Graph View

•	Sybase_MDA Agent SYBM DiskIOSummary Graph View

•	Sybase_MDA Agent SYBM DiskSpaceTrendBar Graph View

•	Sybase_MDA Agent SYBM DiskSpaceTrendChart Graph View

•	Sybase_MDA Agent SYBM EngineInfoDetail Table View

•	Sybase_MDA Agent SYBM EnginePerfDetail Graph View

•	Sybase_MDA Agent SYBM EngineSummary Graph View

•	Sybase_MDA Agent SYBM IndexUse Graph View

•	Sybase_MDA Agent SYBM LockSummary Graph View

•	Sybase_MDA Agent SYBM LockWaitTime Graph View

•	Sybase_MDA Agent SYBM MetaDataCache Graph View

•	Sybase_MDA Agent SYBM MetaDataCacheDetail Graph View

•	Sybase_MDA Agent SYBM NetworkBytes Graph View

•	Sybase_MDA Agent SYBM NetworkPackets Graph View

•	Sybase_MDA Agent SYBM OS Cpu Graph View

•	Sybase_MDA Agent SYBM OS CpuDetail Graph View

•	Sybase_MDA Agent SYBM ProcedureCache Graph View

•	Sybase_MDA Agent SYBM Processes Graph View

•	Sybase_MDA Agent SYBM ProcessesParallel Graph View

•	Sybase_MDA Agent SYBM ResourceConnections Graph View

•	Sybase_MDA Agent SYBM ResourceLocks Graph View

•	Sybase_MDA Agent SYBM ResourceMemory Graph View

•	Sybase_MDA Agent SYBM SybaseConfigChanges Table View

•	Sybase_MDA Agent SYBM TempDbSpace Graph View

•	Sybase_MDA Agent SYBM TempDbSpaceSegment Graph View

•	Sybase_MDA Agent SYBM TempDbSpaceTransLog Graph View

•	Sybase_MDA Agent SYBM TopApplications Table View

•	Sybase_MDA Agent Sybase MDA SYBM TopSQL Table View

•	Sybase_MDA Agent SYBM TopUsers Table View

•	Sybase_MDA Agent SYBM UserLogCache Graph View

•	Sybase_MDA Agent SYBM UsersBlocked Table View

•	Sybase_MDA Agent SYBM UsersBlocking Table View

•	Sybase_RS Agent RS Internal Overview Graph View

•	Sybase_RS Agent RS State Overview Graph View

•	Sybase_RS Agent RS Availability Graph View

•	Sybase_RS Agent RS Availability Text Table View

•	Sybase_RS Agent RS ConnectionDetail Table View

•	Sybase_RS Agent RS ConnectionSummary Graph View

•	Sybase_RS Agent RS ErrorlogDetail Table View

•	Sybase_RS Agent RS ErrorlogSummary Table View

•	Sybase_RS Agent RS ExceptionDetail Table View

•	Sybase_RS Agent RS Health Graph View

•	Sybase_RS Agent RS HealthText Table View

•	Sybase_RS Agent RS Information Table View

•	Sybase_RS Agent RS LatencyTabular Table View

•	Sybase_RS Agent RS Latency Graph View

•	Sybase_RS Agent RS PartitionSpaceUsedSummary Table View

•	Sybase_RS Agent RS PartitionSpace Trend Table View

•	Sybase_RS Agent RS PartitionStatusDetail Table View

•	Sybase_RS Agent RS PartitionStatusSummary Graph View

•	Sybase_RS Agent RS RepAgent Recovery Table View

•	Sybase_RS Agent RS RepAgentStatus Table View

•	Sybase_RS Agent RS SQM Activity Graph View

•	Sybase_RS Agent RS SQM QueueSize Graph View

•	Sybase_RS Agent RS SQM TrailSize Graph View

•	Sybase_RS Agent RS SQM Trend Table View

•	Sybase_RS Agent RS ThreadsSummary Table View

•	Sybase_RS Agent RS ThreadsDown Detail Table View

 

About us

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:

•	Submit and manage a Service Request.

•	View Knowledge Base articles.

•	Sign up for product notifications.

•	Download software and technical documentation.

•	View how-to-videos.

•	Engage in community discussions.

•	Chat with support engineers online.

•	View services to assist you with your product.