Download Foxhound 1.2  -  Free Upgrade!

Get a Foxhound Registration Key  -  which you don't need, if you already have Foxhound installed.

Faster, easier, more powerful: What's New in Foxhound 1.2

Here's the FAQ and the docs.

What is Foxhound?   - Foxhound is a database monitor and a schema troubleshooter for SQL Anywhere.   (more...)

"Foxhound will be a valuable tool for developers, DBAs as well as data center operations personnel."

- Chris Kleisath, Senior Director of Engineering for SQL Anywhere at Sybase iAnywhere
Read Chris' review: Foxhound – A Useful Tool for SQL Anywhere Users

"The schema analysis component of Foxhound can be invaluable in pinpointing schema design issues that can lead to performance problems.
The Foxhound monitor contains a wealth of database tuning experience that can save hours of manual investigation."

- Glenn Paulley, Director of Engineering at Sybase iAnywhere

Foxhound Features

1. "Is my database up?" [next]    [top]    The Alerts feature lets you choose which conditions to watch for: The database is unavailable, there's too little disk space, the server's been using too much CPU, there's been an High Availability failover, there are too many blocked connections, and 24 other conditions. Alert emails include a snapshot of the data gathered by Foxhound: (scroll down for more)
2. "Is my database OK now?" [next]    [top]    Sometimes an Alert condition goes away by itself, or when someone else resolves the problem. When that happens you'll get an "All Clear" email telling you to relax.     Only Foxhound has "All Clear" emails!
3. See what's happening now [next]    [top]    The Monitor page is automatically refreshed every 10 seconds to show the last 10 samples, plus details of the first 10 connections.
4. See what happened yesterday [next]    [top]    The History page lets you scroll through all the old samples and all the connections for each sample. Connections can be sorted on any of the columns. Here, the connections using the most "CPU Time" values are at the top:
5. See blocked connections [next]    [top]    Foxhound answers all your questions: 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?
6. Persistent connections [next]    [top]    The monitor stays connected to the target database 24x7, and it automatically re-connects after an outage even when Foxhound itself is shut down and restarted.
7. Persistent data [next]    [top]    The monitor data is preserved in the Foxhound database as long as you want, all instantly available in the History view.
8. Peak highlighting [next]    [top]    Peak values are displayed as links into the History view, and values that reach 80% or 50% of the peaks are color highlighted.
9. Schema at-a-glance [next]    [top]    Each table is shown as a formatted CREATE TABLE statements with all the information a developer needs: datatypes, defaults, constraints, indexes and relationships, all syntactically correct for copy and paste and up to date at the time of display.
10. Follow the foreign keys [next]    [top]    You can reach each parent and child with a single click: no more "following the lines" on a wall-size diagram.
11. How much space? [next]    [top]    For each table you see how much disk space is used for data, extension pages, keys and indexes. Bytes-per-row numbers include free space so they can be used to calculate future requirements.
12. Find those columns [next]    [top]    All the column names appear in one alphabetic list with hypertext links into the table and view definitions. Plus, you can see at a glance where different data types are used for the same column name in different tables.
13. Facts & Figures [next]    [top]    This page tells you all the names your database goes by: DSN, server, database and machine. It also tells you where all your database files are located, how much free space they contain, and how badly each file is fragmented. Plus, it tells you how big your database is: how many rows, how many bytes, how many tables, columns, indexes, even how many times each different data type is used.
14. What's unusual about this database? [next]    [top]    A "curiosity" is an interesting fact; it may or may not be a problem. If there's something unusual about your database, you'll see it at a glance in the "Database Curiosities" section.
15. What's unusual about this table? [top]    The Table-level Curiosities section shows dozens of interesting facts about individual tables; e.g., no primary key, most bytes per row, large number of secondary indexes, and large amount of index space relative to table space,

Archives...

Download Foxhound 1.1 GA

Foxhound 1.1 FAQ

Foxhound 1.1 Help

This page was last updated on December 3, 2011.      Home      RisingRoad      Breck.Carter@gmail.com