×

TechForum (Dhaka) – Asia Pacific

Date/Time: Saturday, May 09, 2020 08:30 to 11:00 UTC
Location: Virtual

View Event: New features in Management Studio — Performance Troubleshooting made easier !

SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.

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 the 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

I will be speaking at @PASSCloudVC in 3 hours.
10 am PST
1 pm EST
17:00 UTC

Azure SQL Database - Where is my SQL ... Agent?
Registration: https://cloud.pass.org/
#sqlpass #MVPBuzz

#SQLFriday is free Microsoft Data Platform training, delivered by top speakers from the Data Platform community every ... Friday lunch (12:00 CEST), to your computer. Join meetup group at https://meetup.com/Sql-Friday and check out the full schedule at https://sqlfriday.net/schedule

Call for Speakers has reopened! In light of #PASSsummit 2020 becoming a virtual event, we want to give you another ... chance to share your #data knowledge with the #sqlpass community, from anywhere in the world!

Apply Today: http://ow.ly/iuiX50zVWQ0

Load More...