SQL Performance Archives - Page 36 of 54 - SQL Authority with Pinal Dave

Two lobster pots on a harbor quay, one crammed with seaweed and shells, the other holding one lobster.

Query Store Capture Modes: ALL, AUTO and CUSTOM

January 10, 2014

Query Store, SQL Performance, SQL Server, SQL Server Configuration

Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.

Diagram of the infrastructure stack from the internet and firewall through web servers, an app middle tier, databases and the SQL Server instance, down to the operating system, disk configuration, VM and virtual disks; a red callout says Most only tune here at the databases and the instance

SQL Server Performance Stack: Look Beyond the Query

December 25, 2013

Pinal Dave

SQL Tips and Tricks

Disk, Notes from the Field, SQL Performance, SQL Server, Virtualization

Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.

A chimney brush with soot on its bristles beside marked and clean hearth bricks

Investigating a Past Slowdown With the system_health Session

December 24, 2013

Pinal Dave

SQL Tips and Tricks

SQL Extended Events, SQL Monitoring, SQL Performance

Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.

Gouache painting: a convention corridor with three open doorways and a potted palm, one door painted vermilion

SQLLive 360 Orlando 2013: Notes from a Great Experience

December 8, 2013

Pinal Dave

Personal

Conferences, SharePoint, SQL Performance, SQLAuthority Author Visit

I presented three sessions at SQLLive 360 in Orlando, Florida, on November 19 and 20, 2013. It was my first time in Orlando. These are my notes from the event, with a few photos.