Help for Foxhound Beta 1.08.3243a
Table of Contents [RisingRoad]
The History page looks just like the Monitor Database page, except...
you can see more data at one time, and
the display is not automatically refreshed.
The « Back to Menu link displays the main "Foxhound for SQL Anywhere" menu page in the current browser window or tab.
The DSN: / Connection String: title shows the name of the DSN or Connection String that you used to connect to the target database. This identifies the "current target database", a term used in this Help.
The Samples between / Sample at title shows the date/time range for all the samples that were available when this page was displayed.
The Monitor link opens the Monitor Database page in a new browser window or tab.
The Schema link opens the Display Schema page in a new browser window or tab.
The New Menu link opens the Foxhound Menu page in a new browser window or tab.
The Foxhound Options link opens the Foxhound Options page in a new browser window or tab.
The
Help link
is a context-sensitive link to this Help topic.
The About link opens the About Foxhound page in a new browser window or tab.
The button hides this Help frame from view, and brings it back.
« Newest - Scroll to the most recent samples for this database
Tip: Click on « Newest to scroll to the "new top". If sampling is running, new samples will continue to be gathered, and the History page won't automatically show them unless you scroll up.
‹ 100 - Scroll by 100 to more recent samples for this database
‹ 20 - Scroll by 20 to more recent samples for this database
‹ 1 - Scroll by 1 to more recent samples for this database
‹ Month - Scroll by one month to more recent samples for this database
‹ Week - Scroll by one week to more recent samples for this database
‹ Day - Scroll by one day to more recent samples for this database
‹ Hour - Scroll by one hour to more recent samples for this database
1 › - Scroll by 1 to older samples for this database
20 › - Scroll by 20 to older samples for this database
100 › - Scroll by 100 to older samples for this database
Oldest » - Scroll to the oldest sample for this database
Hour › - Scroll by one hour to older samples for this database
Day › - Scroll by one day to older samples for this database
Week › - Scroll by one week to older samples for this database
Month › - Scroll by one month to older samples for this database
The timestamp on the left side
Server version:
Database file version:
Number of CPUs:
The Was running for duration
The Started at timestamp
SP OK: Y or N indicates whether or not Foxhound was using the rroad_connection_properties stored procedure on the target database.
The Database file: specification
The Top Sample section consists of 5 or 6 lines:
The Age: line appears if the top sample wasn't the most recent sample when this page was displayed.
The Age: line appears if the top sample is 15 seconds old or more.
The next line shows most of the sample data.
The Totals: line shows more information for some columns.
The rest of the Top Sample section looks the same as the Most Recent Sample section on the Monitor Database page. This includes the color highlighting:
this color is used for sample values that are 50% as large as the corresponding peak value or larger, but haven't reached 80%.
For Cache Satisfaction and Index Satisfaction the thresholds are inverted: 20% or smaller and 50% or smaller.
Some small values are not highlighted at all, even if they exceed the 80%/50% thresholds:
The Peaks section on the History page looks the same as the Peaks section on the Monitor Database page. What you see in both places are the peak values as they were recorded when the page is displayed. For example, clicking on Reset Peaks on the Monitor Database page will affect what you see on the next History page display.
The Peaks section will disappear from the History page if you scroll back prior to the "Peaks since" timestamp. That's because the peaks don't have any meaning for samples recorded prior to the first peak being recorded.
Clicking on a link in the Peaks section will scroll the History page to that sample in the current browser window or tab, rather than opening a new window.
The Samples section on the History page looks the same as the Recent Samples section on the Monitor Database page, except that 100 samples are displayed instead of 10.
In particular, color highlighting is the same:
This color is used for sample values that are 50% as large as the corresponding peak value or larger, but haven't reached 80%.
For Cache Satisfaction and Index Satisfaction the thresholds are inverted: 20% or smaller and 50% or smaller.
Some small values are not highlighted at all, even if they exceed the 80%/50% thresholds:
The Blocked Connections section on the History page looks the same as the Blocked Connections section on the Monitor Database page, except
a resizable, scrollable frame is used instead of a fixed box, and
you can scroll this section if there are more than 100 blocked connections.
The Connections section on the History page looks the same as the Connections section on the Monitor Database page, except
you can scroll this section if there are more than 100 connections.
[Top]
[Top]