210 likes | 430 Views
Tivoli Decision Support & Capacity Planning. Emfisys - Bank of Montreal. TDS & Capacity Planning at Emfisys Introduction. Combined presentation TDS experience Capacity Planning website Currently using TDS SPP and BMC Patrol Perform & Predict Data from 100+ servers (40+ applications)
E N D
Tivoli Decision Support& Capacity Planning Emfisys - Bank of Montreal For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
TDS Experience at EmfisysTDS Logical Architecture For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
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? For CMG Canada - J.Gladstone, Bank of Montreal
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, can’t 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 For CMG Canada - J.Gladstone, Bank of Montreal
TDS Experience at EmfisysSystem Purpose Matrix Example For CMG Canada - J.Gladstone, Bank of Montreal
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…? For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
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. For CMG Canada - J.Gladstone, Bank of Montreal
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 => Systems projections For CMG Canada - J.Gladstone, Bank of Montreal
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 For CMG Canada - J.Gladstone, Bank of Montreal
Emfisys Capacity Planning WebsiteSample Pages (1 of 5) For CMG Canada - J.Gladstone, Bank of Montreal
Emfisys Capacity Planning WebsiteSample Pages (2 of 5) For CMG Canada - J.Gladstone, Bank of Montreal
Emfisys Capacity Planning WebsiteSample Pages (3 of 5) For CMG Canada - J.Gladstone, Bank of Montreal
Emfisys Capacity Planning WebsiteSample Pages (4 of 5) For CMG Canada - J.Gladstone, Bank of Montreal
Emfisys Capacity Planning WebsiteSample Pages (5 of 5) For CMG Canada - J.Gladstone, Bank of Montreal
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? For CMG Canada - J.Gladstone, Bank of Montreal