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.