Category : Performance - SentryOne Team Blog

Category: Performance

Slides and Scripts: Baltimore SQL Server User Group

Slides and Scripts: Baltimore SQL Server User Group

Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.

A new series on performance-related SQL Server myths

A new series on performance-related SQL Server myths

Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.

The Relativity of Server Health

The Relativity of Server Health

Maintaining a good server health status is critical to your SQL estate performance. Jason Hall discusses why 'healthy' is not a relative measurement.

Image credit clipartsgram.com.

Overview of Columnstore Indexes in SQL Server

Overview of Columnstore Indexes in SQL Server

Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.

15 SQL Server Performance Counters to Monitor

15 SQL Server Performance Counters to Monitor

When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.

Erin Stellato : Capacity Planning Using Performance Data

Erin Stellato : Capacity Planning Using Performance Data

Erin Stellato (@erinstellato) discusses the types of performance data needed to help with capacity planning.

Trust Issues Hurting Database Performance?

Melissa Connors (@MelikaNoKaOi) discusses locating & resolving SQL Server database trust issues (check constraints & foreign keys).

Tim Radney : Getting Started Tuning Performance in Azure SQL Database

Tim Radney (@tradney) of SQLskills talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.

Delayed Durability while Purging Data

Melissa Connors (@MelikaNoKaOi) investigates using SQL Server's delayed durability feature to improve performance while purging data.

Tim Radney : Tuning : A Good Place to Start

Tim Radney of SQLskills gives an overview of his approach to SQL Server performance tuning, from system configuration, to I/O latency, to high cost queries.

Troubleshooting SQL Server Part 4: Correlating Wait Statistics Against Other Metrics

Kevin Kline (@kekline) continues his series on troubleshooting SQL Server; in this post, he shows how to correlate wait stats to other system metrics.

Partitioning on a Budget

Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some partitioning benefits without the Enterprise Edition price tag.