CMG Canada Seminar: Tuesday November 18th 1997


TIME: 8:30a.m. - 4:30p.m.

LOCATION: The Corporate Seminar Centre *** changed venue ***

130 Adelaide St. West, 35th Floor, Toronto, Ontario (Tel: 416-366-4228)

The Centre is located on the top floor of 130 Adelaide St. W. on the North East corner of York and Adelaide. From the lobby of the 34th floor take either the spiral staircase or shuttle elevator to the Penthouse floor. The Centre is within a block of the St. Andrew subway stop and a short walk up York Street from the West end of Union Station.

ATTIRE: Business attire or Business casual (hard soled shoes, slacks, collared shirt)

If this program is not of interest to you, please pass it on to the appropriate group within your organization ... Thanks for your prompt attention.

Agenda:


8:30 AM Continental Breakfast


9:00 AM President's Welcome - Anthony G. Mungal

9:15 AM Annual General Meeting

Election of Directors, Treasurer's Report, Membership Report and other business of CMG Canada. This is a special invitation to members of CMG Canada to come along and participate in this important business activity.

9:30 AM Oracle Performance Tuning for UNIX and Windows NT

Terry Lewis - TMHR Consulting Inc.

What is performance tuning? Who should do it, and when should it be done? The tuning of an Oracle Production system is an art, not a science. The art is in knowing where you will get the biggest "bang for your buck" without having to "RAID" the bank. We will look at what components contribute to bad performance, how to tune them and how to take advantage of new tuning features and functions of Oracle 7.3x and 8.0x. We will also look at some of the differences between running Oracle on UNIX versus Windows NT.

Terry has been around the Toronto computing industry for more than 20 years. His background has been tuning networks, but for the past 5 or six years he has spent most of his time tuning Relational databases such as Oracle and SQLBase for Peoplesoft users and other large corporate clients. Terry has also been very involved in running a number of users groups including the short lived SNA Performance Committee at S.H.A.R.E. many years ago. Until recently, Terry was the co-founder and chairperson of the Toronto

Gupta/Centura Users Group. Currently, he is a member of the Toronto Oracle Users Group executive committee and the co-founder and chairperson of the Rational Users Group of Ontario. Lately, Terry has been working with an SAP, Oracle and Lotus Notes business partner in Germany who has moved part of it's operation to Canada. He is working with the Canadian subsidiary to expand and grow their Oracle and Informix server, Lotus Notes and Application Development side of their business.

10:30 AM Coffee

10:45 AM Performance and Capacity Management in Complex Multi-tier Client/Server Environments (SAP, PeopleSoft, Baan)

Glynn B. Giacone - BGS Systems

Multi-tier client/server application support and simplify business applications in areas of finance, production, distribution, sales, and human resources. Multi-tier architectures typify the strategies of mission critical applications implemented for UNIX and Windows NT, where workstations communicate with application servers which in turn communicate with database servers such as Oracle, Informix, and Sybase. This paper is a client/server case study of what instrumentation is available from UNIX, what instrumentation is

required from a client/server application such as SAP R/3, and how system and subsystem metrics can be used in an analytic model for sizing and capacity planning.

Glynn has been employed at BGS for 16 years, and is currently the Director of SAP Products and Services. Responsible for product line strategies to meet SAP performance and capacity management needs in open system and mainframe environments. Glynn is a technical author and frequent speaker relating experiences and techniques to help size and manage mission critical applications for SAP R/3, Oracle, Sybase, Informix, DB2, CICS, and IMS.


12:00 NOON Lunch (make your own arrangements)


1:30 PM Panel Discussion - Shaping Technologies

Panelists: Anthony Mungal, George Warren, Terry Lewis,

Glynn B. Giacone & 2 other panelists being finalized

Come, hear and participate in a lively 90 minute discussion on a number of timely and engaging issues which continue to shape the course of Data Processing in many organizations today. A sampling of the topics for discussion are as follows:

The Panelists and a few to be added prior to the Seminar day are widely regarded in their field and hence come highly recommended to share experiences and advice with you. A Separate biography including credentials for each one was not undertaken, but will be highlighted prior to the session.

3:00 PM Coffee

3:15 PM A Comparison of Remote Copy Approaches: SRDF and PPRC Performance Testing

Anthony G. Mungal & Rene Daoust - EMC Corporation

As the proliferation of applications supporting critical business functions continue to increase, the need for continuous availability of data and associated subsystems continue to heighten. In fact, the whole "global" nature of many businesses today demand that lines of business function seamlessly across multiple time zones spanning difficult geographic areas. This places an increasing challenge on the personnel, resources and configurations required to support these business functions, hence, an understanding of the performance and availability characteristics of the I/O Subsystems capable of supporting such functions is essential.

This paper details the results of an extensive suite of testing in a customer environment of EMC's Symmetrix Remote Data Facility (SRDF) and IBM's Peer to Peer Remote Copy (PPRC). An initial review of the various modes of Operations and the full assessment of the functionality of each of the two offerings is made. As expected, to the extent that variations exist within and amongst customer environments, the results of this testing will require specific interpretation. The true benefit of this type of testing is the rather comprehensive and quantitative amount of information which becomes immediately applicable to the many situations facing performance analysts, capacity planners, storage management and other technical management personnel.

This Paper will also be presented at CMG'97 International Conference in Orlando this December.

Anthony Mungal is currently President of CMG Canada, and works with EMC in a Consulting role. Prior to joining EMC over four years ago, he spent about seven years with Amdahl Canada Limited in the capacity of Regional Systems Engineer. His employment background prior to that spans several years as a Consulting Systems Engineer, Manager, MVS Senior Systems Programmer, Business Systems Analyst, and Application Development and Programming. He is a graduate of the University of Toronto with honours in both Mathematics and Computer Science. He is a founding director of CMG Canada and is presently serving as the President. He has authored many papers on Capacity Planning, CPU and I/O performance, Disaster Recovery, High Availability, and Storage Management which were presented to various forums including SHARE, miscellaneous User Forums, and local and international CMG conferences.

Rene Daoust joined EMC Corporation as a Corporate Systems Engineer about three and a half years ago in Hopkinton, Massachusetts. His areas of specialty is primarily in architectures and performance. Prior to that, he worked at the Norton Company from 1980 to 1993 in Systems Programming as a Systems Software Specialist, primarily focusing on Operating Systems, having the responsibility of installing and debugging them. He also did a lot of Performance Tuning, Capacity Planning and many other miscellaneous roles. The last 3 years at the Norton Company was spent as a Supervisor of Systems Programming. His ten years of experience prior to the Norton Company spans various roles as Systems Programmer, Manager of Operations and Computer Operator.


4:30 PM Adjourn


Dates worth Remembering:

CMG'97 - Orlando (December 8th - 12th 1997)

The remaining CMG Canada dates for the 1997/1998 year are:

For the latest updates on CMG Canada upcoming programs and other information you can visit our website at:

http://www.cmg.org/regions/cacmg

CMG Canada