Tag Archives: performance

Using Idera to investigate a problem during specific time

I had a situation to troubleshoot a performance problem on a server which occurred a few days back. Following is quick reference on how Idera can be used to drill down details. 1. Select History Icon and select the time … Continue reading

Posted in SQL, SQL Server, Uncategorized | Tagged , , | Leave a comment

QUERY STORE for Azure database performance analysis

Query store can be enabled on Azure SQL Database to analyze any performance issues with SQL Server. Example: Below image indicates one of the SQL statement was executed about 57,000 times along with Query plan to understand what is consuming maximum … Continue reading

Posted in Azure, 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

How Statistics impact the performance of SQL Query

In this article I will run through a simple demo which explains how STATISTICS impact the performance. During this Demo, I will use the Number of Logical Reads as performance indicator (More Logical Reads indicates Performance Degrade) Created a new … Continue reading

Posted in Performance, Script, SQL | Tagged , , , , , , | 1 Comment

SET STATISTICS IO ON; SET STATISTICS TIME ON – performance tuning

SET STATISTICS IO ON and SET STATISTICS TIME ON are beautiful ways which can be used while performance tuning individual queries. SET STATISTICS IO ON Enabling STATISTICS IO is very informative as it displays Scan count, logical reads, physical reads, … Continue reading

Posted in Performance, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment