Help link
is a context-sensitive link to this Help topic.
Help for Foxhound Beta 1.08.3243a
Table of Contents [RisingRoad]
The Display Schema page shows database and table-level "curiosities" and database option and property values as well as CREATE statements for all the tables and views.
2.3 Database-level Curiosities
2.10 The Engine and Database Properties Display
The « Back to Menu link displays the main Foxhound 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 Top link is a shortcut that scrolls the left hand frame to the top.
The Tables: link scrolls the left hand frame to the list of table names.
The table name letter links A B C... scroll the left hand frame to different sections in the table name list.
The Columns: link scrolls the left hand frame to the list of column names.
The column name letter links A B C... scroll the left hand frame to different sections in the column name list.
The Monitor link opens the Monitor Database page in a new browser window or tab. If a sampling session already exists for the current target database, sample data from that session will be displayed. If not, Foxhound will start a new sampling session and display that data.
The History link opens the History page in a new browser window or tab if a sampling session already exists for the current target database.
The New Menu link opens the main Foxhound menu 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.
The Options link displays the current SET OPTION PUBLIC values in the right hand frame.
The Properties link displays the current engine and database properties in the right hand frame.
The Checkpoint and redisplay link sends a CHECKPOINT command to the current target database and then redisplays the entire Display Schema page. This lets Foxhound show fresh row counts and other information that only up to date when a checkpoint is taken. Do not do this on a busy production database unless you are sure that forcing a checkpoint won't hurt performance.
The Foxhound Options link opens the Foxhound Options page in a new browser window or tab.
The Print link lets you print the entire left hand frame: all the Facts & Figures, Curiosities and table and column name lists.
You can click on the Show Facts & Figures and Hide Facts & Figures links to show and hide this section.
The Facts & Figures title line names the target database and shows when this information was gathered for display.
The DSN: or Connection string name: identifies the target database according to how Foxhound made its connection.
Server version: shows the version and build number of the SQL Anywhere engine running the target database.
The Started timestamp shows when the target database was started.
Database file version: shows the version and build number of the SQL Anywhere software that was used to initialize the target database file. For early versions, and for databases that have had the "upgrade" utility run, this field may be somewhat imprecise.
The Created timestamp shows when the target database file was initialized.
Server name: is the currently assigned network server name.
Database name: is the currently assigned network database name.
Machine name: is the name assigned to computer running the database server.
The Server command line options: shows what options were used by the database server when it was started.
Server type: shows what kind of database server is being run; e.g., Network or Personal.
Processor type: is the kind of CPU used to run the database server.
Number of processors available: is the number of CPUs available on the computer running the database server.
Number of processors used: is the number of CPUs actually being used by the database server.
O/S: shows what operating system is being used by the computer running the database server.
Current cache: is the amount of RAM currently being used for the database cache.
The min amount is the lower limit on the size of the database cache.
The peak amount is the largest size actually reached by the database cache.
The max amount is the uper limit on the size of the database cache.
Multi-programming level: is the -gn setting for the database server.
The dbping connect string: is the connection string that was used by an exploratory dbping to determine the type of connection between Foxhound and the target database.
The dbping result: is the description of the connection from Foxhound to the target database made via dbping.
The Client address backtrace: shows the result of network trace back from the target database to the computer running Foxhound.
The DBSPACE section describes each physical file associated with the target database: DBSPACE name, disk file size, free space inside the file, free space on the drive, how badly fragmented the file is, and the full file specification. Note that the Free Space On Drive will be the same for all files that are on the same drive.
The section starting with page size describes various counts and sizes: page size, dbspaces, tables, rows, foreign keys, disk space, columns, and column data types.
The total space amount is made up of disk space used to store table data pages, table extension pages and index pages.
The section starting with permanent (base) tables shows how many and what kind of tables, views and indexes are defined in the database.
You can click on the Show Curiosities and Hide Curiosities links to show and hide both Curiosities sections.
The Database-level Curiosities title line names the target database and shows when this information was gathered for display.
Each database-level curiosity (interesting fact or possible problem) is shown on its own line.
The Largest tables list shows the set of tables that contain at least 80% of the rows in the database and use at least 80% of the disk space.
The Table-level Curiosities title line names the target database and shows when this information was gathered for display.
Each table-level curiosity (interesting fact or possible problem) is shown on its own line, ordered by table name.
The Tables title line names the target database and shows when this information was gathered for display.
The table names are listed alphabetically, and the number of rows shown for each table is up to date at the most recent CHECKPOINT performed on the target database.
The bytes per row amount is based on the disk space used for table data, extension and index pages. It doesn't include free pages in the database, but it does count free space in pages allocated to this table. As such, this number is usually larger, sometimes quite a bit larger, than the average number of bytes a query might return. To avoid showing inflated numbers for very small tables, the bytes per row is only shown for tables with at least 2 data or 2 extension pages.
The Columns title line names the target database and shows when this information was gathered for display.
The columns list is ordered alphabetically by column name and table name. The base data type of each column is shown (no domain names), and differs: is used to highlight any data type differences among columns with the same name.
Each table is shown in valid CREATE TABLE syntax, suitable for copy and paste. Warning messages may appear at the top; for more information click on the Note: link.
The title line includes following fields:
The CREATE TABLE statement includes the row count and disk space used for table data, extension and index pages.
Each column is shown with it's base data type, and if a domain was used it is shown as a "-- domain ..." comment to the right.
Some columns have an "eyecatcher" comment /* PK FK U X */:
The PRIMARY KEY contraint includes a comment showing how much disk space is used by the corresponding index.
The Parents of list contains direct links to this table's referential integrity parents: i.e., other tables that are named in this table's FOREIGN KEY constraints.
The Children list contains direct links to this table's referential integrity children: i.e., other tables that name this table in their FOREIGN KEY constraints.
ALTER TABLE ... FOREIGN KEY statements for each referential integrity constraint defined on this table. These statements include comments showing how much disk space is used by the corresponding indexes.
CREATE INDEX statements are shown for each index defined on this table, not including indexes that are created for each primary and foreign key. These statements include comments showing how much disk space is used by the indexes.
Each view is shown in valid CREATE VIEW syntax, suitable for copy and paste.
The title line includes following fields:
The -- CREATE VIEW comment section shows the view column names base data types.
The CREATE VIEW statement shows the SELECT which defines the view.
The SET OPTION display lets you see at a glance which database options have been changed from the defaults.
The Options title line includes following fields:
The Options with non-default values section shows options whose current values are different from the defaults defined for a recent build of SQL Anywhere. Recently-defined default values are used for the comparisons to take advantage of improvements made over the years. For old databases this often results in several differences showing NULL as the current value for modern options that don't exist in the target database at all.
The Options with default values section shows options with current values which are the same as the default values defined for a recent build of SQL Anywhere.
The properties display gives a snapshot of everything returned by calls to sa_eng_properties() and sa_db_properties().
The Properties title line includes following fields:
The Engine Properties section shows everything returned by a call to sa_eng_properties(), with the property description on the far right.
The Database Properties section shows everything returned by a call to sa_db_properties() for the target database, with the property description on the far right.
[Top]
[Top]