Designing For Performance: Myths and Misunderstandings

Everyone agrees that great database performance starts with great database design. So why do so many poorly designed databases exist in the world? Attend this session to understand why bad designs will always exist, what you can do to avoid them, and how best to work with them when needed. Discussion topics will include:
  • Server/Infrastructure design
    • VM/Server configuration
    • Physical file layouts
    • HA/DR options
    • Archiving
  • Database/Table design
    • Table design
    • PK/FK choices
    • Index strategies
  • Benchmarking
    • Monitoring for performance
    • Control reports
Attendees will leave this session with an understanding of the following:
  • Why common issues are so common
  • How to better anticipate issues before they happen 
  • How to deploy and implement design choices that benefit everyone
  • Proper performance benchmarking and control reports
The day will include lecture style format as well as interactive discussions and exercises. 
Thursday 5 March 2015