You searched for extended events - Page 5 of 6

A First Look at the New SQL Server Cardinality Estimator

Benjamin Nevarez (@BenjaminNevarez) gives us some insight into the new cardinality estimator in SQL Server 2014 – both how it works as well as how to keep the functionality of the current version of the estimator.

Guest Posts ◆ December 19, 2013

9

Transaction Log Monitoring

Paul Randal (@PaulRandal), CEO and owner of SQLskills.com, discusses monitoring the transaction log, as he rounds out his series on transaction log configuration and management.

Paul Randal ◆ November 21, 2013

6

Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1

Joe Sack (@josephsack) looks into some new locking behavior, involving rebuilds and partition switching, available in SQL Server 2014.

Joe Sack ◆ September 18, 2013

1

Parameter Sniffing, Embedding, and the RECOMPILE Options

Paul White (@SQL_Kiwi) discusses the causes of parameter sniffing and goes into detail about the effectiveness of various workarounds.

Paul White ◆ August 28, 2013

24

Observer Overhead and Wait Type Symptoms

Joe Sack (@josephsack) of SQLskills.com shows us that we might not always be able to make an accurate correlation between wait statistics and observer overhead, depending on the method being used to observe a system.

Joe Sack ◆ July 11, 2013

11

How expensive are column-side Implicit Conversions?

Jonathan Kehayias (@SQLPoolBoy) demonstrates column-side implicit conversions and the impact they can have on a workload. He concludes that you can only throw hardware at this problem for so long; a design or code change will be necessary to solve the performance issue long-term.

Jonathan Kehayias ◆ April 15, 2013

7

Performance-related fixes for SQL Server 2012

In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.

Aaron Bertrand ◆ March 19, 2013

1

A Look At DBCC CHECKCONSTRAINTS and I/O

Erin Stellato of SQLskills takes a deep look into the I/O impact of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others.

Erin Stellato ◆ February 28, 2013

8

My Perspective : The Top 5 Most Common SQL Server Performance Problems

As lots of you know already, Kevin Kline (blog|@KEKline) has joined us here at SQL Sentry. I’ve followed Kevin myself for a good while, so I’m really excited to have him here with us.

One of the first things Kevin asked of me was to list the top 5 technical issues we see while providing customer service for SQL Sentry. For our Client Services team, technical support is far more than just supporting our own software products or managing licenses. Everyone on the team is deeply trained in SQL Server, Windows and Microsoft .NET. In fact, in general, any member trained on our Client Services team should be able to walk into the role of a Windows sysadmin, SQL Server DBA or .NET Application Developer with very little adjustment effort.

Jason Hall ◆ August 17, 2012

2

Understanding Execution Plan Operator Timings

How SQL Server actual execution plan operator timings work, and why parallel row mode plan timings can be misleading, by Paul White.

Paul White ◆ March 8, 2021

3

Minimal Logging with INSERT…SELECT and Fast Load Context

Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.

Paul White ◆ May 29, 2019

0