What is SDM?

1. What is SDM? • SDM : Server and Database Monitoring • SDM is the web-based real-time server and database monitoring and reporting tool • Service Items • Server Resource Reporting • Server Monitoring • Database Monitoring • Resource Simulating • TSD Reporting (problem)

2. Web Server (Server Resource Report) httpd Transfer data using FTP Customer Customer Web Layer Real Time Server Resource & Database Monitor Gathering Data using SHELL httpd Internet USF Transfer data using FTP Gathering Data using SHELL Operator SDM Server Server : Linux, Web: Apache DB : rrdtool CGI : Perl5 Analysis Module : Shell, CGI Customer DB Layer Architecture

3. Gathering data Analyzing data Monitoring data Basic Flow • Gather raw data from monitoring target server • Using SHELL script (ex. ksh, perl, awk…) • Basic monitoring items are from Tivoli • User can add an optional items • Polling time : 15 minute (change available) FTP HTTP Agent Layer Analysis Layer Web Interface Layer • Transfer raw data from target servers by FTP • Save raw data to archive directory • Analyzing data using batch or CGI program • CGI : perl * • Graph : gd library * * • Data archive : rrdtool * * * • All of monitoring data and report are provided using Web-interface • Server admin, DBA, operator and customer can use SDM • Only web browser needed • Notification (alarm, mail…) • Auto generating report

4. Characteristic • Simple Configuration • SDM is developed by USF member to overcome Tivoli’s complexity and include essential functions for USF management • Easy Customization • All modules in SDM are SHELL scripts, ksh, perl, awk, so it is very easy to modify and customize program • Auto generated Reports • All regular reports(monthly) are generated without manual operation, and real-time reports are available for customer • Integrated Web Console • All monitoring items are integrated to only one web page so that admin and operators can recognize evnets easily and fastly • Lower Resource consume • SDM consume lower server resource to monitor because SDM is minimized to essential functions

5. Feature1Server Resource Reporting • Report Type • Real time : daily, weekly, monthly, yearly • Regular : Monthly Resource Report for each customer • Report Items • CPU Activity, Free Memory, Virtual Memory, Page in VM, Run Queue Size, Total Disk Usage, Disk IO stat • Special features • Auto Comment : basic comments are served in all reports • Archive : user can save any report to review it later • Registration : easy register new customer and server • Authentication : username/password required • Available OS : AIX, Solaris, Windows 2000

6. Weekly CPU Activity Graph Monthly Regular Report for Customer

7. Feature2Server Monitoring • Monitoring Items • Load Average : run queue size • CPU Usage : % of user call, system call, wait and idle • Disk Usage : each file system disk usage • I-Node Usage : each file system I-node usage • Swap space Usage : swap space usage • Page out count : page out count • Daemon Status : cron, inetd, syslogd, sysdog, esmd, dsmc process check • Special features • Red alarm (fatal), Black alarm (critical), Blue alarm (harmless), Green alarm (normal) • Notification : screen, sound(ring), mail (if mail server available) • Top 10 process : Top 10 CPU consumer process list available for each server • Popup information : all item has popup to provide detailed information • Change thresholds : admin can change threshold value to confront various situations • Available OS : AIX, Solaris, Windows 2000

8. Server Monitoring Console Top 10 Process Popup Window

9. Feature3Database Monitoring • Monitoring Item • Special features • Red alarm (fatal), Black alarm (critical), Blue alarm (harmless), Green alarm (normal) • Notification : screen, sound(ring), mail (if mail server available) • Popup information : all item has popup to provide detailed information • Change thresholds : admin can change threshold value to confront various situations

10. Database Monitoring Console Alert log check Popup Window

11. Feature4Resource Simulating • What is Resource Simulating? • Sometimes, need to show previous monitoring data like a real-time monitoring console ( for example; when you want to show previous night problem status) • You can select • Date, hour, minute (interval 15 minutes) • Speed : slow, normal, fast, very fast • Special features • Monitoring items : Same to server monitoring • PAUSE/CONTINUE : you can pause simulation and continue • STOP : you can stop simulate • Any time you want to see

12. Choose Date to simulate Simulate Monitoring

13. Feature5TSD Reporting • Problem reports from TSD Database • Daily Report : problem list generated from yesterday • Weekly Report : for problem meeting • Monthly Report : for problem analysis • Search Problem : investigate problem by keyword • Special features • Web-based report : overcome TSD’s weak point; reporting • Print Format : print format available • Easy Customizing : only SQL statement using Perl and DBI • Graphical Interface

14. Daily Problem Report Weekly Problem Report

15. Server/Software for SDM • Server Requirement • Target Servers: No restriction (AIX, Solaris, W2k) • Analysis Server : No restriction (Linux, Unix) • Software • Target Server • ksh, awk, perl5 • Analysis Server • gd library • zlib • rrdtool : v1.0.28 • Perl 5 : DBI, DBD for DB2, DBD for Oracle