Print ISSN: 1681-6900

Online ISSN: 2412-0758

Author : Ali Salman, Asia

Design and Implementation of Performance Counters for Real Time Database Server Clients

Asia Ali Salman

Engineering and Technology Journal, 2010, Volume 28, Issue 8, Pages 1672-1691

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.