March 27, 2018 – Performance Troubleshooting Made Easier- New Features in Management Studio

Taiob Ali

Performance Troubleshooting Made Easier- New Features in Management Studio

March 27, 2018, 6:00pm

Taiob Ali

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.

Speaker Bio

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.

Important meeting information:

We meet at the offices of Wayfair, upstairs from the Copley Place Mall, at 4 Copley Place, Boston.

Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.

Typical Meeting Format:

6:00pm – 6:30pm — food / beverages, networking and group discussion

6:30pm – 6:45pm — news, announcements, upcoming training opportunities

6:45pm – 8:15pm — guest speaker presentation