Performance History Files

Lab128 can save performance data into files with .LAB extension. The Performance History Files window helps to locate the files needed to explore database activity at certain period of time. This window can be activated from the Main menu | Instance | Open Performance Data File or by using the shortcut in the Toolbar. All .LAB files presented in this window are located in the current directory. The current directory can be changed by editing the "Path" or by browsing the file system with the "Select Folder" dialog window. The list of files is further filtered by Database Name selected in the "Database" box. If "ALL" is selected, nothing is filtered out. These two filters - "Path" and "Database" - are pre-populated with values obtained from the instance which had focus before opening this window.

The information about these files is obtained from the operating system and from the header block of the .LAB file. If there are many .LAB files in the directory, the information in some columns doesn't show immediately. This columns are filled automatically as data becomes available.

Once a file is selected, it can be opened using the "Open Selected" button. Multiple files can be selected by pressing and holding the Shift key. Currently only files in adjacent rows can be multiple-selected. As with single-file selection, the selected files can be opened in one click. They also can be deleted by right-clicking and choosing "Delete Selected".

Selecting time zone to show time.

Internally, all data in .LAB files is stored in the UTC / GMT time zone. Use the "Show Time in Time Zone" radio buttons to show time in UTC / GMT or the time zone configured for the workstation.

Information in the status bar.

The status bar provides information about size of .LAB files. It has four sections:

• Number and total size of all selected files;
• Number and total size of all files shown in the list. These don't include files filtered out by the "Database" filter;
• Number and total size of all .LAB files in a selected directory;
• Amount of free space on the disk and the size of the disk where selected directory is stored.

This information helps to monitor free space on disk and make a decision if some files can be deleted. See above on how to delete files.