Copyright: Copyright © 1982-2001 Pervasive Software Inc. All Rights Reserved.


Pervasive Software Monitor Utility

The Monitor utility enables you to monitor various resources being used by the MicroKernel. These resources include:

 Detailed information about open files

 Detailed information about active users

 Current, peak, and maximum values for files, handles, locks, transactions, etc.

 Current, peak, and maximum values for various remote communications statistics

Menu options available from the Monitor Utility include:

Options

MicroKernel

Window

SQL

Help

The right-hand portion of the status bar at the bottom of the main window indicates which server is being monitored.  When the local server is being monitored, Local is displayed. When connected to a remote server, the name of the remote server is displayed.

See the Help Contents for a brief description of all of the dialog boxes available in the Monitor utility. You can view many of these dialogs box at the same time. You can display and move between several dialog boxes at one time. Each dialog box enables you to manually or automatically refresh the information.


MicroKernel Active Files

The MicroKernel Active Files dialog box shows information about all files which are currently opened by the MicroKernel engine.

Active MicroKernel Files

Active MicroKernel Files List

File Information

Page Size

Read-Only Flag

Record Locks

Transaction Lock

Current Files Handles

Current Files Handles List

Handle Information

Connection Number

Task Number

Site

Network Address

Open Mode

Record Lock Type

Wait State

Transaction State

Automatic Refresh Check box

Refresh

Close

Help


Shows the number of active files.


Active MicroKernel Files List
Contains the complete path of all open files. Select the file from this list for which you want to see detailed information.


File Information
Contains file specific information for the currently selected file in the Files list.


Page Size
Shows the internal page size of the selected file.


Read-Only Flag
Indicates whether the file is marked read-only by the operating system.


Record Locks
Indicates whether or not any of the active handles for the selected file have record locks. Any application can read a locked record, but only the application that placed the lock can modify or delete the record. A record lock exists only as long as the application that opened the file is updating a record. Yes indicates that one or more record locks are applied to the file; No indicates that no records are locked.


Transaction Lock
Indicates whether any of the active handles for the selected file have a transaction lock. A transactional file lock exists only as long as the application that opened the file is processing a transaction.


Current Files Handles
Shows the number of active handles for the selected file. A handle is one instance of a file being opened.


Current Files Handles List
Contains the active handles associated with the selected file. Each handle is represented by either a user name (typically the login ID of the user) or an index into the engines client (user) list. Select the handle from this list for which you want to see detailed information.


Handle Information
Contains handle-specific information for the currently selected handle in the Handle list.


Connection Number
Displays the network connection number of the client. If the client does not have a network connection, this field displays N/A.


Task Number
Contains the process-supplied task number for the processes originating at the file server, or a Windows workstation. For DOS workstations, this field displays the dynamic socket number.


Site
Displays the location of the user process (local or remote).


Network Address
Displays an identifier representing the location of the calling process on the network.

If the calling process is SPX, the network node/network address will be preceded by S:. For example, S: 65666768 00000000001.

If the calling process is TCP/IP, the dotted-decimal notation will be preceded by T:. For example, T: 180.150.1.24.


Open Mode
The method the application uses to open the specified handle to the file. Possible methods include:

  - Accelerated

  - Exclusive

  - Normal

  - Read-only

When applicable, the open modes are specified as non-transactional or shared locking.


Record Lock Type
Indicates the type of record lock(s) currently held by this handle. Possible values include:

  - Single

  - Multiple

  - None


Wait State
Indicates whether the user is waiting due to some type of lock on this handle. Possible values include:

- Waits for File Lock

- Waits for Record Lock

- None


Transaction State
Indicates the current type of transaction lock held by this handle. Possible values include:

  - Concurrent

  - Exclusive

  - None


Automatic Refresh Check box
Select this check box to automatically update the information in the dialog box every few seconds.

Tip

You can change the refresh time for all dialog boxes by selecting Options | Settings and changing the value in the Refresh Rate (Seconds): option .


Refresh Button
Manually refreshes the information.


Close Button
Closes the dialog box.


Help Button
Shows help for this dialog box.


MicroKernel Active Users

The MicroKernel Active Users dialog box shows information about all users currently accessing the MicroKernel engine.

Active MicroKernel Users

Active MicroKernel Users List

User Information

Connection Number

Task Number

Site

Network Address

Locks Used

Transaction State

Records Read

Records Inserted

Records Deleted

Records Updated

Disk Accesses

Cache Accesses

Selected Users Handles

Selected Users Handles List

Handle Information

Open Mode

Record Lock Type

Wait State

Transaction State

Automatic Refresh

Delete Current User

Delete All Users

Refresh

Close

Help


Active MicroKernel Users
Shows the number of active clients.


Active MicroKernel Users List
Contains all of the active clients using the engine. Each client is represented by either a user name (typically the login ID of the user) or an index into the engines client (user) list.

Select the client from this list for which you want to see detailed information.


User Information
Contains client (user) specific information. This information corresponds to the currently selected user in the User list.


Locks Used
The number of locks currently being used by this user.


Records Read
The number of records this user has read since they first opened a file.


Records Inserted
The number of records this user has inserted.


Records Deleted
The number of records this user has deleted.


Records Updated
The number of records this user has updated.


Disk Accesses
The number of times this user has required a disk access. You will not see any information for disk accesses for files that have just been opened.


Cache Accesses
The number of times this user has required a cache access.


Selected Users Handles
Shows the number of active handles for the selected user. A handle is one instance of a file being opened.


Selected Users Handles List
Contains the active handles associated with the selected user. Each handle is represented by the filename associated with that handle.


Delete Current User Button
Deletes the currently selected user.


Delete All Users Button
Deletes all of the current MicroKernel users.


MicroKernel Resource Usage

The MicroKernel Resource Usage dialog box shows information about various resources used by the MicroKernel engine. The maximum, peak, and current values are shown for each statistic.

Files

Handles

Clients

Worker Threads

Licenses in Use

Transactions

Locks

Automatic Refresh

Refresh

Close

Help


Files
Indicates the number of active files. You set the maximum for this field when configuring the MicroKernel with the Configuration utility (Open Files option).


Handles
Indicates the number of active handles. The MicroKernel creates a handle each time a user opens a file; therefore, a single user can have several handles for the same file. You set the maximum for this field when configuring the MicroKernel with the Configuration utility (Handles option).


Clients
Indicates the number of clients accessing the MicroKernel. A workstation can have multiple clients accessing the engine simultaneously.

Tip

You can set the maximum for this field using the Pervasive Control Center and the Configuration utility. Select (Active Clients option).

You can change the refresh time for all dialog boxes by selecting Options | Settings and changing the value in the Refresh Rate (Seconds): option.


Number of Worker Threads
Indicates the number of concurrent MicroKernel processes. You set the maximum for this field when configuring the MicroKernel with the Configuration utility (Number of Worker Threads option).


Licenses in Use
Indicates the number of users as defined by your licensing agreement. In this case, the maximum shows the number of users your licensing agreement allows.


Transactions
The number of transactions currently in use. The maximum for this field is unlimited.


Locks
Indicates the number of record locks. The maximum for this field is unlimited.


MicroKernel Communications Statistics

The MicroKernel Communications Statistics dialog box shows information about communication between the MicroKernel and remote clients. A total for all protocols and protocol specific information is displayed. You can view protocol specific information for SPX, TCP/IP and a second SPX or TCP/IP. The second SPX or TCP/IP will be displayed as SPX(2) or TCP/IP(2). Below is a list of the controls in this dialog box and their function:

Total Requests Processed

SPX Requests Processed

TCP/IP Requests Processed

Communications Threads

Total Remote Sessions

SPX Remote Sessions

TCP/IP Remote Sessions

Automatic Refresh

Refresh

Reset Delta

Close

Help


Total Requests Processed
Indicates the number of requests the Communications Server handles from workstations or remote, server-based applications for all communication protocols. Total indicates the number of requests processed since the Communications server was loaded. Delta indicates the number of requests since you first invoked the Communications Statistics dialog box. To reset this number to zero, click Reset Delta.


SPX Requests Processed
Indicates the number of requests the Communications Server handles from workstations or remote, server-based applications for SPX. Total indicates the number of requests processed since the Communications server was loaded. Delta indicates the number of requests since you first invoked the Communications Statistics dialog box. To reset this number to zero, click Reset Delta.


TCP/IP Requests Processed
Indicates the number of requests the Communications Server handles from workstations or remote, server-based applications for TCP/IP. Total indicates the number of requests processed since the Communications server was loaded. Delta indicates the number of requests since you first invoked the Communications Statistics dialog box. To reset this number to zero, click Reset Delta.


Communications Threads
Indicates the number of remote requests that the MicroKernel is currently processing. Local requests are not included in this statistic. For the total number of remote and local threads being processed, see the Resource Usage dialog box. You set the maximum for this field when configuring the Communications Server with the Configuration (Number of Communications Threads option).

Communications threads are also used to process Monitor utility requests, so you may not see the number of current worker threads drop below one; this is normal.


Total Remote Sessions
Indicates the number of remote workstations connected to the Communications Server for all communication protocols. You set the maximum for this field when configuring the Communications Server with the Configuration utility (Number of Sessions option).


SPX Remote Sessions
Indicates the number of remote workstations connected to the Communications Server through SPX.


TCP/IP Remote Sessions
Indicates the number of remote workstations connected to the Communications Server through TCP/IP.


Reset Delta Button
Manually resets the Delta count to zero for Total Requests Processed, SPX Requests Processed and TCP/IP Requests Processed.


Settings
Monitor Settings

The Monitor Settings dialog box enables you to view or change several Monitor utility configuration options. To adjust database-specific settings, use the Configuration utility. Below is a description of each of the Monitor utility settings:

Save Settings on Exit

Save Window Layout on Exit

Refresh Rate

OK

Cancel

Help


Save Settings on Exit
Select this check box to save all configuration settings when you close the Monitor utility. The Monitor utility saves both the settings in this dialog box and the automatic-refresh option in the various dialog boxes.


Save Window Layout on Exit
Select this check box to save the state (open or closed) and screen location of all open windows. When you start the Monitor utility again, these windows are automatically opened and positioned for local file server monitoring. This enables you to easily reproduce your preferred layout.


Refresh Rate
This option allows you to specify how often the Monitor utility updates the information on any open dialog boxes where the automatic-refresh option is enabled.


OK Button
Saves the selected settings.


Cancel Button
Closes without saving any changed settings.


Connect

The Connect dialog box allows the user to enter a server name and connect to a remote file server for monitoring.  By default, the Monitor utility connects to the local server.

If any dialog boxes are open in the Monitor utility window, the Connect... option is unavailable, and you cannot connect to a remote server. Close any open dialog boxes and then select the Connect... option.

Server Name

OK

Cancel


Server Name
Enter the server name in the Server Name text box and click OK.

Click Cancel if you do not want to connect to a remote server.


OK Button (Connect)
Connects to the server listed in the Server Name text box. The server name will appear in the lower right corner of the status bar.


Cancel Button (Connect)
Closes without connecting to a remote server. The Monitor utility continues monitoring the local server.


Disconnect

The Disconnect dialog box asks the user if they want to disconnect from the remote file server to which they are currently connected.

If any dialog boxes are open in the Monitor utility window, the Disconnect... option is unavailable, and you cannot disconnect from the remote server. Close any open dialog boxes and then choose the Disconnect... option.

Yes

No


Yes Button
Clicking Yes issues a disconnect to the remote file server. Upon completing, the Monitor utility monitors the local file server.


No Button
Clicking No cancels the disconnect to the remote file server. The Monitor utility continues monitoring the remote file server.


About

The About dialog box displays various product information, including the name, version, and copyright of the Monitor utility.


Options

The Options menu offers the following options:

Settings...

Connect...

Disconnect...

Exit


MicroKernel

The MicroKernel menu command offers the following options:

Active Files...

Active Users...

Resource Usage...

Communications...


Exit

Exits or closes the Pervasive Software Monitor Utility


SQL

The SQL menu command contains the following option:

Active Connections...


SQL Connection Manager Active Sessions

Active Sessions

User Name

Sessions Information

Client Host Name

Network Address

Client Application

Data Source Name

Connection Status

Active/Idle Period (ms)

Total Connection Time (s)

Refresh Session List

Delete Session

Close

Help

Automatic Refresh


Displays the number of active SQL Connection Manager sessions.


User Name
Displays the list of connected user names. User Name is set by default to the Windows login ID. If this is unavailable, User Name is set to "unknown".


Sessions Information
Contains specific information about the selected User Name's session.


Client Host Name
Displays the client's machine or host name for the selected User Name. If this is unavailable, this is set to "Unknown".


Network Address - SQL Connection
Displays the client's IP or NetWare address for the selected User Name.


Client Application
Displays the connected application or module for the selected User Name.


Data Source Name
Displays the Engine DSN name referenced by the client application.


Connection Status
Displays the Connection Status for the selected User Name. The following connection statuses are possible:

  - Active

  - Idle

  - Dying

  - Unknown (if status is unavailable)


Active/Idle Period (ms)
Displays the time, in milliseconds, since the connection has been active or idle.


Total Connection Time (s)
Displays the time, in seconds, since the connection was established.


Refresh Session List
Refreshes the current session list.


Delete Session
Deletes the session for the currently selected User Name.


Window

This menu command displays all the resources you are currently monitoring. You can view many of these dialogs box at the same time. You can display and move between several dialog boxes at one time. Each dialog box enables you to manually or automatically refresh the information.


MON_MK_MAIN_HELP_CNTXT