Pedro Lopes
aka.ms/sqlserverteam
Pedro Lopes is a Principal Program Manager in the Azure Data SQL Server team, focusing on the Relational Engine for SQL Server and Azure SQL (Query Processor, Query Performance, Programmability).
SQLBits 2018
0 to Hero: Troubleshooting SQL Server Performance Made Easy
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.
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.