New course: Introduction to Query Store

Our first new course of the year, and our 50th online training course with Pluralsight!! Erin’s latest Pluralsight course has been published – SQL Server: Introduction to Query Store – and is just over three hours long. It’s based on her very popular user group and conference session, but much expanded with lots of cool demos. The modules are: Introduction […]

What are LOGMGR_RESERVE_APPEND waits?

Last week I was sent an email question about the cause of LOGMGR_RESERVE_APPEND waits, and in Monday’s Insider newsletter I wrote a short explanation. It’s a very unusual wait to see as the highest wait on a server, and in fact it’s very unusual to see it at all. It happens when a thread is […]

Code to show rolled back transactions after a crash

In Monday’s Insider newsletter I discussed an email question I’d been sent about how to identify the transactions that had rolled back because of a crash, and I said I’d blog some code to do it. First of all you need to know the time of the crash. We can’t get this exactly (from SQL Server) unless SQL Server […]

Summer 2017 classes in Bellevue open for registration

I’ve just released our second set of classes for 2017 for registration! Our classes in July/August will be in Bellevue, WA: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 July 31-August 4 IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 August 7-11 Note that there is a full set of […]