The "Remote Diagnostic Tool" Project is designed to monitor the hardware systems operation, data storage, transmitted by these systems and representing different statistic information graphically and tabular.

Tool allows the monitoring of up to 100 systems of different type, each of them can send to the TCP Socket up to 3 packets in a second.

Full configured Tool accepts and processes 300 packets in a second.

The main interest of the project is in the usage of a great number of different technologies such as: Javascript and Ajax for UI organization, that is the RIA implementation (Rich Internet Application).

Difficulties

• The huge volumes of information stored and as a result is not acceptable inquiry processing for data sampling and inserting. The problem was solved in stages. Firstly, the Table Partitioning technology was used. For the data inserting process optimization the BATCH INSERT was used, and then it was substituted for INSERT on the COPY command usage in combination with the temporary files creation on RAMDrive.
• The other problem appeared with the UI reliable performance. At frequent (5 timers with different polling periods were defined in interface) server polling, the Internet Explorer browser was crashing. The problem was partially solved by minimizing a number of timers and partially substituting iframes for content-based AJAX.

Screenshots: