Design and implementation of performance counters for real time database server clients

Abstract EN

The aim of this research is to monitor, check, and do the necessary refinements for the performance of clients working with Database server in the real time environment.

If there are a number of clients in the network need to access Database server designed for distributed real time system in particular sequence, this will cause many bottlenecks in the system, making the work of the system unstable, especially in critical systems such as that of power and water distribution.

A designed performance counters and objects were added to each client to know who makes the bottlenecks, also they will be used while developing and debugging the clients when they access the Database server on the network in order to tune the performance of the system.

After completing the designed system and installing it at the target, the counters can help system administrators to adjust configurable settings for that system.

Using this new performance counters in the execution time will help to see the effect of clients on each other, on network, and on performance of the Database server.

The results show that, the designed performance counters can detect the bottlenecks which are caused by week points in Client’s program code, so they will help the programmers to amendment and redistribute the client’s program code on the network with minimum errors when accessing DB server.Windows NT/XP/2000 provides a mechanism for developers to add performance objects and counters for their applications and other software components.

These objects and counters can provide performance data to Windows NT/XP/2000 Performance Monitor.