Plan optimization from DBA to Developer

2016

TL; DR

Maximise resolution time with some joined up thinking between developers and DBAs. We'll show how to identify poorly performing SQL, how to navigate and analyse its plan and how to increase performance, and cover some free tools to help connect you resolve issues faster.

Session Details

This session looks at how to maximise resolution time with some joined up thinking between developers and DBAs. Martin Wild and Peter O Connell will run through a workflow showing how to identify poor performing SQL, how to navigate and analyse its plan and how to optimize for better performance. They will introduce some free tools to help you on your way and help connect your developers and DBAs to resolve issues faster.

3 things you'll get out of this session

Peter O’Connell's previous sessions

Is the DBA Dead?... or Alive (and Preparing for the Future)?

DBAs are living in a world of constant flux. This session analyses research on the how the role is evolving, the concerns facing DBAs today and valuable insights on the DBAs path to career success. Learn how the megatrends of our industry and are shaping the role of the DBA today.

Martin Wild's previous sessions

Monitoring AzureSQLDB

Join this session to learn how managing performance is even more critical with Azure SQL DB. Learn what key performance indicators are most applicable, what auto-tuning really means and get some tools to help you identify and fix issues.

Lifting the lid on SQL Server on Linux

Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He will explore the mechanics to deploy SQL Server on Linux, what is and is not in the current Linux build and share some of quirks, and observations on setup and config.