Tivoli Decision Support

1
Tivoli Decision Support Capacity Planning

• Emfisys - Bank of Montreal

2
TDS Capacity Planning at EmfisysIntroduction

• Combined presentation
• TDS experience
• Capacity Planning website
• Currently using TDS SPP and BMC Patrol Perform
  Predict
• Data from 100 servers (40 applications)
• Small fraction of BMO total server farm, will
  expand to 1,500
• Historical data kept for capacity planning, daily
  reports to intranet

3
TDS Experience at EmfisysBackground

• Using BMC Patrol since 1997
• Data from 40 servers, almost 20 services and
  growing
• Looked at alternatives summer 2000
• Tivoli onsite strategic
• BMC Patrol Datametrics Viewpoint also onsite
• Evaluated TDS, Patrol, Viewpoint
• Installed TDS in production January 2001
• Database moved February 2002

4
TDS Experience at EmfisysTDS Logical Architecture
5
TDS Experience at EmfisysConfiguration

• All data from single TMR
• Soon to collect from three more
• Many gateways
• Single TDS server handles all functions
• TDS application, Cognos cubes, also Oracle
  databases (SPP, maybe others)
• SPP database on TDS servers
• Gives TDS users access to raw data
• Inventory database helps billing costing

6
TDS Experience at EmfisysSuccesses

• Collecting performance data from 100 production
  servers
• Producing daily reports for 40 business
  applications on BMO intranet
• Benefit to application support teams
• Using database with other business information to
  produce capacity updates
• Planning to expand to 1,500 servers
• More efficient capital expense dollars

7
TDS Experience at EmfisysChallenges (1 of 4)

• Job timeout applies to response only
• All Tivoli, not just TDS
• e.g. aggregation and database population jobs
• Timed-out job task continues to run
• Need longer baseline for extrapolating trends
• 6 months may exclude seasonal peaks
• e.g. Christmas, RRSP season
• Enhancement requested Oct/2000, available?

8
TDS Experience at EmfisysChallenges (2 of 4)

• Need workload characterization
• Servers will soon run multiple applications
• Need differentiation between actual and forecast
  data
• e.g. on Hourly views, cant tell which is which
• Requirement not yet raised to Tivoli
• Need System Purpose matrix
• Replace single unsorted text-only variable in
  Cube 3 with a matrix with sorting, etc.
• Enhancement requested Oct/2000

9
TDS Experience at EmfisysSystem Purpose Matrix
Example
10
TDS Experience at EmfisysChallenges (3 of 4)

• Database maintenance and product recovery
  functions should be delivered
• Oracle database cleansing, re-org, tuning, etc.
• Aggregation file backup
• DM event(s) for RIM failure, data collection
  failure
• Control over data collection retries
• Population job log file cleansing or rollover
• New version difficulties
• Implementation of DM 4.0 has yielded 42 layers
  instead of 18?

11
TDS Experience at EmfisysChallenges (4 of 4)

• Graphics flexibility
• Changes sometimes not accepted in TDS
• Using Cognos as delivered with TDS helps but
  design capability still limited
• Exploring full-function version of Cognos, but
  need to know if new TDS will use it
• Want to include capacity threshholds on charts
• Web output
• JPG output files too big, GIF smaller
• Enhancement requested Oct/2000
• Automated thumbnails would be nice

12
TDS Experience at EmfisysOpportunities

• Expansion planned to over 1,500 servers
• Capacity planning and performance reporting
  handled by three-person team
• Enabled by top-down ability to focus on servers
  trending towards trouble or running off trend
• Looking to evaluate TDS Oracle, UDB, Notes and
  TSM Discovery Guides

13
TDS Experience at EmfisysConclusions

• TDS has potential to allow a small team to handle
  capacity planning for a very large number of
  servers
• Require Tivoli support
• Database tuning
• Product enhancements
• Server purpose matrix
• Graphics flexibility
• etc.

14
TDS Capacity Planning at EmfisysInterlude - CP
at BMO

• Data collection
• Collect raw performance data from systems
  applications, aggregate to repositories
• Performance reporting
• Publish to intranet daily or...
• Data inspection
• Learn trends and usual patterns
• Problem notification to support teams as needed
• Capacity Planning!
• Business / systems history plus business
  projections gt Systems projections

15
Emfisys Capacity Planning WebsiteBackground

• Website in existence for many years
• MVS and other data updated daily or as needed
• UNIX data added starting 1997
• UNIX website redesigned 1999/2000
• Reorganize data by type of service
• Group charts to avoid scrolling pages
• Show daily data week by week
• Development continues
• Add application data, improve groupings
  accessibility

16
Emfisys Capacity Planning WebsiteSample Pages (1
of 5)
17
Emfisys Capacity Planning WebsiteSample Pages (2
of 5)
18
Emfisys Capacity Planning WebsiteSample Pages (3
of 5)
19
Emfisys Capacity Planning WebsiteSample Pages (4
of 5)
20
Emfisys Capacity Planning WebsiteSample Pages (5
of 5)
21
TDS Capacity Planning at EmfisysDiscussion

• Anyone else using TDS SPP for capacity planning
  or performance reporting?
• Successes, challenges, opportunities
• Anyone using TDS Oracle, UDB, Notes or TSM
  Discovery Guides?
• Anyone else presenting performance data for large
  numbers of servers?

• Questions?