I/Watch

1
I/Watch

• Weekly Sales Conference Call Presentation(See
  next slide for dial-in details)
• Andrew May
• Technical Product Manager
• Dax French
• Product Specialist

2
Dial-in Instructions

• Time When requested
• USA Phone [phone]
• International 1-706-634-7209
• Leader Andrew May
• Conf. Id Quest Software
• Notes
• Please mute your phone using 6. Unmute to talk.
• Please do not put your phone on hold!

3
The Quest Application Management Platform
DEVELOP/DEPLOY
MANAGE
4
Database Administration Challenges

• The high level goal is to provide a computer
  system that
• Is always available when users need it
• Gives acceptable performance
• Does the job in terms of functionality (although
  this may be of no importance to a DBA)
• Database Administrators play a key part in the
  first two of these goals
• How do we do this..

5
Database Administration Challenges

• DBA functions include
• Make sure the backup is done right!
• Make sure there is enough space in the database
• Make sure there is always space for archive logs
• SQL and database tuning
• Consult with Developers about Oracle technology
• Install and upgrade software

6
Database Administration Challenges

• DBA functions
• Reacts to unplanned events
• Is both proactive and reactive
• Interacts with other groups like systems,
  networks, end users, etc.

7
Database Management
Detect
Resolve

• Spotlight
• Pinpoint bottlenecks
• Identify offensive SQL
• Analyze space

• LiveReorg and SQLab Xpert w/ (RECON)
• Tune database parameters
• Tune SQL
• Reorganizations

• Foglight and I/Watch
• 24x7 proactive monitoring
• Auto-alarms
• Actual transaction flows

Maintain
Implement Changes - Data Migration Archiving
Capacity Planning
8
What Should a Monitor Do?

• Tell you when there is a failure before the users
  do
• Run proactive checks 24x7 (that may prevent the
  failure)
• Notifications via Pager, E-mail and consoles
• Record historical information
• Present information in a better way (graphically)
• Make access to critical data easier
• Have low overhead
• Improve the availability and performance of your
  applications
• Be extensible to do the things you want

9
What Can I/Watch Do?

• Notifies you based on predefined or user defined
  conditions
• Presents information as graphs, tables or HTML
• Shows you activity rates
• Stores information for later review
• Works unattended 24x7
• You dont have to remember all the SQL
• You can still use your own scripts
• Monitors many databases at once
• Low overhead, easy to install and maintain

10
Product Features

• Sends the correct command syntax to each database
  or operating system
• O/S agent gets information directly from the
  kernel
• Inbuilt scripting language
• Automatic discovery of database and O/S
• Monitor NT and UNIX from a single console
• Easy to customize

11
Product Architecture
12
Supported Environments

• Oracle 7.3 thru 8i
• MS SQL Server 6.5 and 7.0
• Sun Sparc, HP-UX, IBM AIX, Windows NT/2000,
  Compaq Tru64 (Digital Unix)
• Oracle Applications 10.7 and 11.0

13
Product Advantages

• Low resource consumption
• Easy to implement and maintain
• Can be installed in about 30 minutes
• No physical server access required for
  installation
• Central administration
• Intuitive Interface

14
Product Advantages

• Focused tuning on the database
• Rapid Identification of bottlenecks
• Developed by DBAs for DBAs
• Shows data that is useful, rather than everything
• Easy to customize
• Oracle Applications integration

15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
I/Watch for Oracle Applications

• Whats special about Oracle Applications
• Multiple components to keep running
• Concurrent manager
• Bottleneck is usually at month end processing
  (the accounting cycle)
• An ERP package, but usually has added reports and
  sometimes interfaces to other systems

23
I/Watch for Oracle Applications

• How does I/Watch for Oracle Applications help?
• Monitors the status of critical components 24x7
• Helps you manage concurrent requests
• Identifies poorly performing programs/reports
• Shows the application user, program and form, not
  just the Oracle user

24
(No Transcript)
25
(No Transcript)
26
In Summary

• Quest Software offers the most complete
  monitoring, diagnostics and high availability
  solutions on the market today.

27
(No Transcript)