may, 2022

Warning: in_array() expects parameter 2 to be array, bool given in /home/customer/www/ on line 60

25may8:00 am9:30 amWhat is hidden in the query plan?Rudi Bruchez

Event Details

What are memory grants ? How can we see wait statistics for a query ? Can we have some warnings if our query is misbehaving ? Yes, we can. All those details are now in the query plan. More and more, new version after new version, Microsoft is adding invaluable information in the actual query plan. If you can understand it, you can solve many of your performance problems. In this session, we will open the query plan, look at its XML content, open Plan Explorer, and analyze some tough queries.