1 / 23

Val Robertson Senior DBA

Val Robertson Senior DBA. Aims. Introduction to HBOS HBOS I3 experience Wish list. HBOS Estate. Mixture of servers, databases and database releases UNIX (IBM, HP, Solaris) Windows (NT, XP) DB2 Oracle (7.3.4 – 10g) SQL Server. HBOS Team. 50 DBAs across 4 sites

bolinger
Télécharger la présentation

Val Robertson Senior DBA

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Val Robertson Senior DBA Valerie Robertson HBOSplc

  2. Aims • Introduction to HBOS • HBOS I3 experience • Wish list Valerie Robertson HBOSplc

  3. HBOS Estate • Mixture of servers, databases and database releases • UNIX (IBM, HP, Solaris) • Windows (NT, XP) • DB2 • Oracle (7.3.4 – 10g) • SQL Server Valerie Robertson HBOSplc

  4. HBOS Team • 50 DBAs across 4 sites • Aylesbury, Chester, Edinburgh, Pudsey • + Financial and Development DBAs around HBOS Valerie Robertson HBOSplc

  5. HBOS Challenge • New projects • Application upgrades • Infrastructure upgrades and consolidation • Problem resolution Valerie Robertson HBOSplc

  6. HBOS Toolset • I3 for Oracle and SQL Server • Oracle Enterprise Manager • TOAD • Quest Central for SQL Server • Spotlight for Oracle Valerie Robertson HBOSplc

  7. HBOS I3 experience • Oracle User Group conference in 2000 • Installation at Intelligent Finance Valerie Robertson HBOSplc

  8. HBOS I3 experience • Product enabled Intelligent Finance (IF) to overcome a major problem just after going live Valerie Robertson HBOSplc

  9. Drilling down in Precise we found that running multiple copies of a daily task caused a problem. • Because the system ran slowly for 8 hours, all end users experienced long response times and were severely impacted, with obvious impact on IF’s online business. Valerie Robertson HBOSplc

  10. Valerie Robertson HBOSplc

  11. In September 2001 we made changes to various SQL, some were identified using Precise • The overall effect was to reduce the total Oracle CPU time consumed from: 410.85 hours in August to 45.09 hours in September Valerie Robertson HBOSplc

  12. HBOS I3 experience • Rollout to other major databases • Customer Service Centre • Bank of England reporting • Share dealing • etc Valerie Robertson HBOSplc

  13. Valerie Robertson HBOSplc

  14. Valerie Robertson HBOSplc

  15. HBOS I3 experience • Installations driven by • Strategic decisions • Performance Issues Valerie Robertson HBOSplc

  16. HBOS I3 experience • Interaction with supplier • Precise • Veritas • Symantec Valerie Robertson HBOSplc

  17. HBOS I3 experience • Training for DBA team • Rollout to customers Valerie Robertson HBOSplc

  18. HBOS I3 experience • Veritas Clustering software and I3 interaction • Sales contacts and I3 awareness Valerie Robertson HBOSplc

  19. HBOS wish list - monitoring • Evaluation exercise of current products • Training on Oracle 10g enterprise manager • Recommendation, rollout and control of user tools Valerie Robertson HBOSplc

  20. HBOS wish list – I3 • Increase team awareness and use of I3 • Looking to extend installation of I3 to additional systems • Organise training on use of Foresight to prevent incidents Valerie Robertson HBOSplc

  21. Monitoring Key to unlocking performance and reliability Valerie Robertson HBOSplc

  22. Performance is our Business Upgrading ORACLE 8i to 9.2 on Windows (almost) painlessly

  23. Performance is our Business Upgrading ORACLE 8i to 9.2 on Windows (almost) painlessly

More Related