Pervasive logo

Prev Advanced Operations Guide Next

Monitoring MicroKernel Resources


This section describes the following options for monitoring the MicroKernel:

Setting Screen Refresh Options

You can refresh the information in the Monitor utility dialog boxes either automatically or manually, as follows.

Viewing Active Files

To view active MicroKernel files

In the upper left of the dialog box, the Monitor utility displays the Active MicroKernel Files list. This scrollable list contains the complete path of all open files in alphabetic order.

To view more information about a particular file

In the upper right of the MicroKernel Active Files dialog box, the Monitor utility displays the Selected File's Handles list. This scrollable list contains the active handles (users) associated with the selected file. Each handle is represented by a user name (typically the login ID of the user), or by an index into the engine's client (user) list.

To view more information about a particular user

Some handles have an agent identifier, a two letter code that specifies the application that initiated the session.

Table 11-1 lists the agent IDs used by Pervasive.SQL components.

 
Table 11-1 Agent IDs 

Agent ID
Application or Component
BT
Maintenance utility for the Btrieve 7.0 (BUTIL)
DE
Database Services client
DC
Database Services login
DR
DOS client Requester
ML
MicroKernel logging and roll forward
NR
Win32 client Requester
NX
Maintenance utility for the Scalable SQL 4.0 (SQLUTIL)
PU
Pervasive.SQL utilities
SC
Scalable SQL 4.0 login
SE
SQL Interface
WR
Windows client Requester

The File Information box displays detailed information about the selected file. The Handle Information box displays detailed information about the selected handle.

File Information

The File Information box displays the following information about each file:
Page Size
Indicates the size in bytes of each page in the file.
Read-Only Flag
Indicates whether the file is flagged as read-only by the operating system.
Record Locks
Indicates whether 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.

Handle Information

The Handle Information box displays the following information about each file:
Connection Number
Displays the network connection number of the client. If the client does not have a network connection, this field displays NA (for not applicable).
Task Number
Displays the process-supplied task number for processes originating at the server, or a Windows client. If the process originates at a DOS client, this field contains the communications protocol socket number.
Site
Specifies the location of the user process (local or remote).
Network Address
Identifies the location of the calling process on the network. If the calling process is SPX, then network node/network address is preceded by S: such as S: 65666768 00000000001. If the calling process is TCP/IP, the dotted-decimal notation of the IP number is preceded by T: such as T: 180.150.1.24.
Open Mode
Indicates the method the application uses to open the specified handle of the file. Valid open modes are:
Normal-The application that opened the file has normal shared, read/write access to it.

Accelerated-The application that opened the file has shared read/write access.

Read-only-The application that opened the file has read-only access; it cannot modify the file.

Exclusive-The application that opened the file has exclusive access. Other applications cannot open the file until the calling application closes it.


The Monitor utility also specifies all open modes as non-transactional or shared locking when applicable.
Record Lock Type
Displays the type of record lock(s) currently held by the handle. The possible record lock types are Single, Multiple, and None.

Single-record locks enable a user to lock only one record at a time. Multiple-record locks enable a user to lock more than one record at a time.
Wait State
Indicates whether the user is waiting due to some type of lock on this handle: Waits for Record Lock, Waits for File Lock, or None.
Transaction State
Displays the state of the transaction lock currently held by the handle. The possible transaction types are Exclusive, Concurrent, or None.

Viewing User Information

You can view a list of current users and files, as well as file handles for each user.

To view MicroKernel user information

In the upper left of the dialog box, the Monitor utility displays the Active MicroKernel Users list. This scrollable list contains the names of active users in alphabetic order. Each user is represented by a user name (typically the login ID of the user) or by an index into the engine's client (user) list.

To receive more information about a particular user

Each client is represented by either a user name (typically the login ID of the user) or an index into the engine's client (user) list. Table 11-1 lists the agent IDs used by Pervasive.SQL components. SeeUser Information for specific details about the information available.

In the upper right of the MicroKernel Active Users dialog box, the Monitor utility displays the Selected User's Handles list. This scrollable list contains the active handles (files) associated with the selected user. The MicroKernel creates a handle each time a user opens a file; therefore, a single user can have several handles for the same file.

To view more information about a particular file handle

User Information

The User Information box displays the following detailed information for the selected user handle:
Connection Number
Task Number
Site
See Site .
Network Address
Locks Used
Indicates the number of locks the user is currently using.
Transaction State
Displays the type of transaction lock the user currently holds. The possible transaction types are Exclusive, Concurrent, or None.
Records Read
Displays the number of records read since the user first opened a file.
Records Inserted
Displays the number of records the user has inserted.
Records Deleted
Displays the number of records the user has deleted.
Records Updated
Displays the number of records the user has updated.
Disk Accesses
Indicates the number of times the user required a disk access. You will not see any information for disk accesses for files that have just been opened.
Cache Accesses
Displays the number of times the user required a cache access.

Handle Information

When you click on a specific file handle, the following information about that handle is displayed in the lower right corner of the window:
Open Mode
Record Lock Type
Wait State
Transaction State

Deleting Current Users

To delete a user

Viewing MicroKernel Resource Usage

To view MicroKernel resource usage

  1. Choose Resource Usage from the MicroKernel menu. The MicroKernel Resource Usage dialog box appears, as shown in Figure 11-6 .

     
    Figure 11-6 MicroKernel Resource Usage Dialog Box

This dialog box allows you to view the total resources in use by the MicroKernel since it was loaded.The MicroKernel Resource Usage dialog box shows the following statistics for each resource:


Note
The maximum values for most of these parameters are controlled dynamically by the engine. The maximum value is shown for backwards compatibility purposes only.
Files
Indicates the number of active files.
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.
Clients
Indicates the number of clients accessing the MicroKernel. A workstation can have multiple clients accessing the engine simultaneously. You set the maximum for this field with the Configuration utility (see Active Clients ).
Worker Threads
Indicates the number of concurrent MicroKernel processes.
Licenses in Use
Indicates the number of connected client licenses in use as defined by your licensing agreement. In this case, the maximum shows the number of users your licensing agreement allows.
Transactions
Indicates the number of transactions. The maximum for this field is unlimited.
Locks
Indicates the number of record locks. The maximum for this field is unlimited.

Viewing MicroKernel Communications Statistics

To view MicroKernel communications statistics

  1. Choose Communications from the MicroKernel menu. The MicroKernel Communications Statistics dialog box appears, as shown in Figure 11-7. This dialog box shows you the network requests, worker threads, and sessions in use by the Communications Server since it was loaded.

     
    Figure 11-7 MicroKernel Communications Statistics Dialog Box

The MicroKernel Communications Statistics dialog box shows the following statistics for several of the communications resources:


Prev
Setting Monitor Utility Options
Contents
Up
Check for Revisions
Next
Monitoring SQL Interface Resources