New in Management Studio, Performance Troubleshooting made easier! ~ Taiob Ali

Rhode Island SQL Server User Group
Rhode Island SQL Server User Group
Public group
Location image of event venue


• What we'll do
New features in Management Studio and Showplan -- Performance Troubleshooting made easier!

With the release of SQL Server 2016 fundamental changes were made to SQL Server Management Studio (SSMS) and Graphical Execution Plan (Showplan). SSMS is updated each month with the latest version of the SQL Client Tools.

Do you know that ‘Vulnerability Assessment' per Database and Availability Group latency between replica's can be reported from within SSMS? 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, an accomplished technical leader with proven record of success. His experience includes three major business sectors: financial industry, e-commerce and healthcare. He is a Microsoft and MongoDB certified Data professional with over 11 years of IT experience both on premise and cloud. 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 a DBA lead. Focusing on automation, improving and streamlining operational workflow, plan and prepare for cloud migration. He is a regular speaker at user groups and SQL Saturday events.

• What to bring

• Important to know