Take charge of any performance issue coming your way. "SQL Server is hurting!" Turn feelings to symptoms, and become the hero that saved the day. Streamline the process of troubleshooting performance issues with new tools and capabilities, for faster insights and effective turnaround.   The agenda includes:
  • Query Performance troubleshooting fundamentals.
  • Analyzing query plan properties (Getting the execution context – what properties are available and what do they give you in showplan).
  • Analyzing query plan properties (warnings and context, runtime stats).
  • Bringing it all together with lightweight profiling and live troubleshooting scenario.
All of the above includes latest content introduced in SQL Server 2017 since RTM.
(no tags)
Presented by Pedro Lopes at SQLBits 2018