SQL Server Logical Reads – What do they really tell us?

SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading

Lack of Memory

It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.

SQL Server Logical Reads – What do they really tell us?

In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading

Perfmon

Automatic Query Performance Tuning in SQL Server Database

In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.

Automatic Plan Correction

Parameter Sniffing In Action

This article will demonstrate what is parameter sniffing and how can it can kill performance

Five Mistakes Performance Tuners Make

Erik Darling explains why your queries aren't scaling in production.

SQLCMD compact Performance

SQLCMD performance