Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?
In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
Taiob Ali, Data Platform MVP, is an accomplished technical leader with a proven record of success. He has spent the last 13 years working with SQL Server and MongoDB platform both on-premise and cloud. His experience includes three major business sectors: financial industry, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects including large data migration, complex process design, testing and deployment, performance tuning, long term capacity planning.
Taiob is currently working at “GMO LLC” as lead DBA. Focusing on automation, improving and streamlining operational workflow, plan and prepare for cloud migration. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays and Azure conferences.