What's Cool (in Foxhound 1.1)
What's New (in Foxhound 1.2)
Foxhound Alerts tell you if something bad is happening:
- can't connect,
- slow response,
- blocked connections,
- high CPU,
- I/O bottleneck,
- and 24 other symptoms.
Now you can use Gmail to send the Alerts as well as receive them.
See: How do I tell Foxhound to send Alert emails via the Gmail SMTP server smtp.gmail.com?
Foxhound can monitor up to 100 databases.
Now it's easier to manage large numbers of Monitor sessions:
- The hard-to-find "Alerts Criteria" page has been redesigned and elevated as the "Monitor Options" page.
See: The Monitor Options Page.
- The Default Settings can be directly edited on the Monitor Options page, separate from the options for any particular target database.
See: Monitor Options - Switch Display.
- The Force Default Settings On All Targets button on the Monitor Options page lets you publish new settings to all the targets.
See: Save And Restore Alerts Criteria Defaults.
- The Manage Multiple Monitor Sessions feature lets you specify batches of target databases, and the Start and Stop All Sessions buttons let you turn sampling on and off for each batch.
See: Manage Multiple Monitor Sessions.
The Monitor tab on the Foxhound Menu page shows all the target databases at a glance.
The Monitor tab is now easier to use, and more informative:
- The Disable Refresh and Enable Refresh buttons make it easier to scroll down to look at something.
- The lists of targets and outstanding Alerts have been vertically squished so you don't have to scroll down so far when you've got lot of targets.
- More "at a glance" columns have been added:
- Active Alerts count, with a link down into the Alerts list
- Waiting Req
- Locks Held, Blocked Conns
- CPU Time
- Temp Space
- Disk Reads, Writes
- The Start All Sampling and Stop All Sampling buttons let you turn sampling on and off for all the targets.
See: The Monitor Tab.
The History page shows all the details for an individual database at a glance.
You can also see all the blocked connections:
- You can what happened overnight, yesterday, as far back as you want,
- even the connections,
- and the connections can be sorted on any of the columns, like "CPU Time" and "Locks Held".
- Who's blocked?
- What are they waiting for?
- How long have they been waiting?
- Who's holding the locks?
- What kind of locks are they?
- What tables?
- What rows?
- How long has it been since they last did a commit?
Scrolling through gigabytes of data used to be slowwwww, like continental drift, now it's faster.
New scroll amounts have been added (500 samples and 3 hours):
« Newest « 500 « 100 « 20 « 1 sample 1 sample » 20 » 100 » 500 » Oldest »
« Month « Week « Day « 3 Hours « 1 Hour 1 Hour » 3 Hours » Day » Week » Month »
The "Freeze Frame Heights" button lets you resize and freeze the History page frames so they don't reset ("Grrr!") every time you scroll.
See: The History Page.
It's your data: Foxhound lets you run adhoc queries.
New views have been added for adhoc reporting.
A separate read-only "Adhoc Schema" database lets you see what the views and underlying tables look like.
New connection-level columns have been added to make queries easier to write:
Except for LockRowID, all the new columns contain values that Foxhound used to calculate only when the data was displayed on the Monitor and History pages; now these values are calculated once and stored permanently.
LockRowID BIGINT NULL
blocked_connection_count BIGINT NOT NULL DEFAULT 0
current_req_status VARCHAR ( 100 ) NOT NULL DEFAULT ''
cache_satisfaction DECIMAL ( 30, 0 ) NOT NULL DEFAULT 0.0
time_connected BIGINT NOT NULL DEFAULT 0
total_waits BIGINT NOT NULL DEFAULT 0
waiting_time DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0
transaction_running_time BIGINT NOT NULL DEFAULT 0
time_since_last_request BIGINT NOT NULL DEFAULT 0
index_satisfaction DECIMAL ( 30, 0 ) NOT NULL DEFAULT 0.0
See: How do I run adhoc queries on the Foxhound database?
Foxhound automatically copies and upgrades all of your data when you install a new version.
The upgrade process handles all the schema differences between the old and new versions of the Foxhound database, no matter what the old and new versions are (well, as long as the new version isn't older than the old version :).
The data upgrade process now runs faster, even though it has to work harder in version 1.2 to add all those new columns.
You also have control over how much data to upgrade:
What's really cool about the new upgrade process is you can use it to purge, shrink and reorganize the Foxhound database: just reinstall the same version of Foxhound with FOXHOUND1UPGRADE = yyyymmmdd or FOXHOUND1UPGRADE = n.
- The default is FOXHOUND1UPGRADE = ALL to copy all the data from your old Foxhound database to the new one.
- If you choose FOXHOUND1UPGRADE = OPTIONS during the installation process, Foxhound will copy everything except the Monitor samples. When you start Foxhound again, all the old sample data will be gone but sampling will start again right away (assuming it was running before you installed the new version).
- If you want to save the Monitor samples recorded since a particular date, specify FOXHOUND1UPGRADE = yyyymmmdd.
- To save the samples recorded during the past n days, use FOXHOUND1UPGRADE = n.
How do the different FOXHOUND1UPGRADE values work?
How do I shrink the size of the Foxhound database?
Foxhound supports target databases running all versions of SQL Anywhere from 5.5 through 12.0.1.
Good news, bad news: