version 11.2
4D Server v11 SQL has a comprehensive and user-friendly administration window.
This window provides different analysis and control tools for published databases. The window contains eight pages that can be accessed using the buttons at the top:
Each page is detailed in a section of this chapter.
Note: The administration window can be accessed from a remote 4D machine. For more information about this point, please refer to the Administration from Remote Machines section.
The Monitor Page displays dynamic information concerning database use as well as information about the system and the 4D Server application:
Note: Under Windows, the display of this information is related to the rights of the user that opened the session. For more information, please refer to the "Display of Monitor Information (Windows)" paragraph.
Graphic Area
The graphic area lets you see the evolution in real time of three parameters: the CPU usage, network traffic and memory. You select the parameter to be displayed via a menu found in the center of the window:
CPU Usage: Overall CPU usage of the machine, for all applications taken together.
The specific part of 4D Server in this usage rate is provided in the "Processors" information area.
Network: Number of bytes received per second by 4D Server.
The number of bytes sent by 4D Server is provided in the "Network" information area.
Memory: Quantity of RAM memory of machine used by 4D Server.
A more detailed view of memory use is provided in the "Memory" information area.
Overview Area
The "Overview" area provides various information concerning the system, application and licenses installed on the 4D Server machine.
Details Area
The "Details" area repeats part of the information displayed in the graphic area and provides additional information as well.
Hard drive: Overall capacity of the hard disk and distribution of the space used by the database data (data file + data index), the space used by other files and the free space available.
Memory: RAM memory installed on the machine and amount of memory used by 4D Server, by other applications or that is free.
The memory used by 4D Server can also be displayed dynamically in the graphic area.
Processors: Instant occupancy rate for processor(s) of the machine by 4D Server and by other applications. This rate is constantly recalculated.
The occupancy rate by 4D Server can also be displayed dynamically in the graphic area.
Network: Instantaneous number of bytes received via the network by 4D Server and number of bytes sent by the application. This value is updated constantly.
The number of bytes received by 4D Server can also be displayed dynamically in the graphic area.
Display of Monitor Information (Windows)
Under Windows, some of the system information displayed on the Monitor page are retrieved via the Windows "Performance Analyzer" tools. These tools can only be accessed when the user that opened the session where 4D Server was launched has the necessary authorization. This user must either:
belong to the "Administrators" group,
under Windows Vista: belong to the "Power Users" (for a user that is not an Administrator).
To place a user that is not an Administrator in the "Power Users" group under Windows Vista (you will need to use an Administrator account to carry out these operations):
1. Go to the Control Panel and open the "User Accounts" panel.
2. Click on the "Advanced" tab and then on the "Advanced" button in the "Advanced user management" section.
The "Local Users and Groups" application is run.
3. Double-click on the "Groups" folder.
4. Double-click on the "Power Users" group.
A window named "Power Users Properties" appears.
5. Click on the Add... button in order to add a user.
6. In the text area titled "Enter the object names to select," enter the user names that you want to authorize.
7. Click OK (twice).
Close the "Local Users and Groups" application then the "User Accounts."