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.