I watch
This presentation is the property of its rightful owner.
Sponsored Links
1 / 27

I/Watch™ PowerPoint PPT Presentation


  • 96 Views
  • Uploaded on
  • Presentation posted in: General

I/Watch™. Weekly Sales Conference Call Presentation (See next slide for dial-in details) Andrew May Technical Product Manager Dax French Product Specialist. Dial-in Instructions. Time:When requested USA Phone:1-800-850-2903 International:1-706-634-7209 Leader:Andrew May

Download Presentation

I/Watch™

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


I watch

I/Watch™

Weekly Sales Conference Call Presentation(See next slide for dial-in details)

Andrew May

Technical Product Manager

Dax French

Product Specialist


Dial in instructions

Dial-in Instructions

  • Time:When requested

  • USA Phone:1-800-850-2903

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


The quest application management platform

High Availability

Application Offloading

Monitoring & Diagnostics

DB Server Development

Performance Tuning

The Quest Application Management Platform

DEVELOP/DEPLOY

MANAGE


Database administration challenges

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……..


Database administration challenges1

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


Database administration challenges2

Database Administration Challenges

  • DBA functions…

    • Reacts to unplanned events

    • Is both proactive and reactive

    • Interacts with other groups like systems, networks, end users, etc.


Database management

Diagnose

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


What should a monitor do

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


What can i watch do

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 don’t 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


Product features

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


I watch

SNMP

I/Watch

Agent

DB

UNIX

Windows NT

I/Watch

Agent

DB

NT

Windows 98

UNIX

NT

I/Watch

Agent

App

Remote SQL Net

Windows 2000

I/Watch

Server

I/Watch

Clients

I/Watch

Agent-Only

Installations

Product Architecture


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

Supported Environments


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

Product Advantages


Product advantages1

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

Product Advantages


I watch for oracle applications

I/Watch for Oracle Applications

  • What’s 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


I watch for oracle applications1

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


In summary

In Summary

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


  • Login