I spend my most of time in a day helping client improve their SQL Server Performance at Comprehensive Database Performance Health Check. The biggest performance improvement we often get by tuning the server configuration, and database deployment. However, there are moments when we need to tune the queries as well. When we have to tune the query, there are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan.
When we are working SSMS, it usually splits the SQL Query Editor into the two parts. This is very convenient for most of the time. It helps us to look at the execution plan, results, statistics along with the query. However, there have been moments when we are turning the SQL Server Execution Plan and we have to resize the screen continuously multiple times because we want to see more of the execution plan.
Trust me this is extremely annoying as well as frustrating if you are an SQL Server Performance Tuning Expert. Resizing the screen all the time is not fun as well as it wastes your valuable time. In the following video, I explain, how you can get the full-screen results as well as the execution plan.
Once you watch the above video, do let me know your feedback. I have also included SSMS tip at the end of the video. You can subscribe to watch my more videos here on my YouTube Channel.
Reference: Pinal Dave (https://blog.sqlauthority.com)