Category Archives: Execution Plan

Address High CPU on SQL Server

Following are the guidelines to troubleshoot High CPU scenario in MSSQL Server and fix the problem. 1. Identify running SQL statements taking more CPU 2. Find sql_handle, using SQL handle find average execution time in ms, Number of executions, and … Continue reading

Posted in Execution Plan, Performance, SQL, SQL Server, Uncategorized | Tagged , , , | Leave a comment

SQL Execution plan deep dive (05-Sort)

Note: This blog is continuation to earlier blog: SQL Execution plan deep dive (04-Spool) In this blog we will see how sort impacts the performance. Fundamentally sorting is used across most of execution plans and it works good with small … Continue reading

Posted in Execution Plan, SQL | Tagged , , , | Leave a comment

SQL Execution plan deep dive (04-Spool)

Note: This blog is continuation to earlier 3 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) 3.       SQL Execution plan deep dive (03-Scan, Key Lookup) In simple terms spools are like storing the … Continue reading

Posted in Execution Plan, Performance, Productivity, SQL, Uncategorized | Tagged , , , | Leave a comment

SQL Execution plan deep dive (03-Scan, Key Lookup)

Note: This blog is continuation to earlier 2 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) In the next few blogs, I will cover following topics which can be analyzed during … Continue reading

Posted in Execution Plan, knowledge, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment

SQL Execution plan deep dive (02-Basics II)

This blog is a continuation to SQL Execution plan deep dive (01-Basics I) which explains what an execution plan is and different execution plan components. How to view different execution plan details: Execution plan can be viewed in 3 different … Continue reading

Posted in Execution Plan, SQL, SQL Server, Uncategorized | Tagged , , , , | 2 Comments

SQL Execution plan deep dive (01-Basics I)

Majority of DBAs and Developers think about converting Scan into Seek after analyzing execution plan. This is a good start but is not sufficient to address most of the performance problems. I will start with basics in this blog and … Continue reading

Posted in Execution Plan, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , | 2 Comments