Performance Tuning

FOLLOW ME:

RECENT POSTS:

Forgot my SA password, and I don't have sysadmin rights...

Page Splits, should I worry?

Capture Query Information with Extended Events

DBCC CheckDB on a large Database

New TempDB TraceFlag

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server. When not working I like to lift weights, play music, and travel with my wife.

Page Splits, should I worry?

I wish page splits were delicious. What are page splits? Page splits occur when a data page gets filled with data and a new page is...

Capture Query Information with Extended Events

Many of us have not made the effort to switch from profiler to Extended events. It's 2018, if you haven't found a few hours to learn...

New TempDB TraceFlag

In the past we're used to enabling Traceflags 1117 and 1118 in order to help with TempDB Contention. With the release of SQL 2016, these...

Does SQL Server need more memory? Page Life Expectancy

Page Life Expectancy is the number of seconds the average page of data has been in the buffer pool.SQL server keeps data pages in memory...

Use Cases for Query Store

Why should I use Query Store? Query store can be used for a number of things. For example: Find out what was happening on my server last...

Query Store Overview

It's amazing that we never had a built in feature that logged historical record of queries. Sure we had the plan cache, but that was...

Clear cache for a single Stored Procedure

Sometimes for testing purposes (or an emergency) one might find it useful to remove query plan for a single stored procedure. This way...

RESOURCE_SEMAPHORES

I know, it sounds like it could be a desert. But it's poison! You ever have one of those Saturday morning emergencies and come face to...

Using Diskspd To Test Storage

It's important to test your storage performance especially prior to installing or deploying a new SQL Server. Microsoft has provided us...

Reading the Deadlock Graph

It's important to be able to analyze the deadlock graph once it's been detected. I'm going to give a brief run down on what I look at....