1 / 15

What is SDM?

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) . Web Server

zion
Download Presentation

What is SDM?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related