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.