The Complexity of Metrics

We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.

Performance Monitor Data

How Do You Experiment?

Today Steve is asking you if you experiment in your database.

Extreme SQL

Steve looks at how Facebook accelerates SQL queries.

SQL Server 2019 Feature

Memory Grant Feedback

Set Statistics Time Examples for Tuning SQL Server Queries

The SQL Server set statistics time statement displays the number of milliseconds to parse, compile, and execute a T-SQL query statement. This set statement is widely used to assess times to implement a query statement. The set statistics time statement reports the CPU time and elapsed time for performance tuning.

What Write Ahead Logging Is and Why It Matters

Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.

Query Performance Diagnostics with sp_PerfSQ

This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.

How Bad are Bad Page Splits?

A look at bad page splits and how they affect your database.