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
Architecture
3
Basic Flow
FTP
HTTP
Agent Layer
Analysis Layer
Web Interface Layer

• 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)

• 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
  Tivolis 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 TSDs 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