Dear All,
Greetings !
So far I have been monitoring the database health and performance with the help of scripts as and when essential(daily/weekly monitoring) and required. Since few days I am thinking of having the dashboard in place that can present the information in statistics numbers as well as graphs. I also had discussion over the same with our development team to design such dashboard. To move ahead with the same, I would like experts opinion on:
1. What will be the suitable language to design and code the dashboard ?
2. Since I am talking about the fetching the information from database on periodic basis (Trends), will it incur the additional burden on database performance ?
3. What shall be the appropriate way to fetch the information with out putting additional burden ?
4. Currently I am have monitoring scripts that accommodate the need of required information, will it suitable to integrate those script in a functions and execute those as to fetch information ?
I am aware that there are various tools are already available in market but I would like to give a try myself to server the purpose. I would also wish to have your ideas and opinion on the same.
Thanks and Best Regards,
Krishna