what is sdm l.
Download
Skip this Video
Download Presentation
What is SDM?

Loading in 2 Seconds...

play fullscreen
1 / 15

What is SDM? - PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'What is SDM?' - zion


Download Now 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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)
architecture

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
basic flow

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
characteristic
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
feature1 server resource reporting
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
slide6

Weekly CPU Activity Graph

Monthly Regular Report for Customer

feature2 server monitoring
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
slide8

Server Monitoring Console

Top 10 Process Popup Window

feature3 database monitoring
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
slide10

Database Monitoring Console

Alert log check Popup Window

feature4 resource simulating
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
slide12

Choose Date to simulate

Simulate Monitoring

feature5 tsd reporting
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
slide14

Daily Problem Report

Weekly Problem Report

server software for sdm
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