Who is overriding MAXDOP 1 on the instance?

In Monday’s newsletter I discussed an email question I’d been sent and promised to blog about it. The question was “how can latch waits for ACCESS_METHODS_DATASET_PARENT occur when the instance MAXDOP is set to 1?” This shouldn’t happen, as that latch is only used for coordination between threads performing a parallel table/index scan. However, just […]

Presenting at SQLSaturday Dublin in June

  Although we won’t be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday Dublin in June – our first SQLSaturday ever!   My workshop details: Performance Troubleshooting Using Waits and Latches One of the first things you should check when investigating performance issues […]

New class: Immersion Event on PowerShell for SQL Server DBAs

We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. It’s a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class you’ll have […]