Search Results for &#8220;extended event&#8221;

Note: this is coming to you from the past due to technical difficulties. This week, Brent and Erik discuss Availability Group issues, database diagram tools, AWS vs Azure, diagnosing async io waits, troubleshooting deadlocks, extended events, using same login credentials for everyone in the company, adjusting and more. Here’s the video on YouTube: You can…

Adaptive Blog Posts

Last Updated October 2, 2017

Adaptive Joins, Execution Plans

It turns out I can be dumb In a previous blog post about Adaptive Joins, I thought that EXISTS wasn’t supported by the new feature. It turns out that EXISTS is totally 100% supported, as long as your indexes support EXISTS. To show this, I need to show you a query that gets an Adaptive…

[Video] Office Hours 2017/08/30 (With Transcriptions)

Last Updated September 5, 2017

This week, Brent, Erik, and Richie discuss Availability Groups, versions of sp_BlitzIndex™, SQL Server installation issue, backing up SSRS reports, SQL Server on Linux, failovers, detaching/attaching databases, extended events, career progression of a DBA, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen…

What If Week: What Would You Fix Or Change?

Last Updated August 4, 2017

SQL Server

For this week’s What If series, we’re exploring what would happen if you had access to SQL Server’s source code – like if you got a job at Microsoft, signed a partner NDA, if the code leaked, or if it went open source. Today’s question is, “What would you fix or change?” Erik says: Dynamic…

1.5 Lab 2 Solution: What We’re Looking For (8m)

Last Updated August 7, 2017

Brent talks about the lab’s top wait types, and how indexes influence those wait types. He explains why adding the right indexes will reduce those wait types, and how dropping the not-so-good indexes will help too. He shows the sp_BlitzIndex parameters he’ll use, and when he would escalate to using Extended Events to track down…

You’ll need a membership to access this course. Check out my training classes.

[Video] Office Hours 2017/07/05 (With Transcriptions)

Last Updated July 11, 2017

This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar Unlimited, and what DBA topics they struggle with the most. Here’s the video on YouTube: You can register to attend next week’s Office…

Why Is Tracking Restores So Hard?

Last Updated June 21, 2017

Backup and Recovery, SQL Server

Phantom of the Nopera Let’s say you have a server. Let’s go one step further and say SQL Server is running on it. Crazy, I know. But hey, we specialize in crazy, here. If you want to track CREATE, ALTER, or DROP DATABASE commands, that’s easy enough with DDL triggers. But guess what? None of…

Trainable SQL Servers

Last Updated June 14, 2017

Production Database Administration

Funny thing The human body is pretty good at adaptation. When you get sick or injured, your body responds and (most of the time) heals itself up. When you stress your body in a certain way, over time, your body will feel less stressed by the same level of that activity. If you do 10…

[Video] Office Hours 2017/06/14 (With Transcriptions)

Last Updated June 19, 2017

This week, Brent, Erik, Tara, and Richie discuss setting up an archive process, CTEs vs temp tables, deadlocks, alternatives to replication, Erik and Brent’s pre-con for this year’s PASS Summit, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy…

Direct Seeding: I’ve Got A Wizard And You Don’t

Last Updated May 26, 2017

Always On Availability Groups, High Availability

A commenter commented That the “New AG Wizard” in SSMS 2017 had surfaced the Direct Seeding mode for AGs. I was pretty psyched about this because I think it’s a great feature addition to AGs that can solve for a pretty big hump that people run into when they create databases regularly. It used to…

Do SQL Server 2017’s Adaptive Joins Work with Cross Apply or Exists?

Last Updated May 19, 2017

Adaptive Joins, SQL Server 2017

I think I’ve mentioned that the most fun part of new features is testing them with old ideas to see how they react. It occurred to me that if Adaptive Joins didn’t work with APPLY, I might cry. So, here goes nothin’! Cross Simple Cross Apply…ies can use Adaptive Joins, though at first glance there’s…

Adaptive Joins And SARGability

Last Updated May 12, 2017

Adaptive Joins, SQL Server 2017

There’s a famous saying Non-SARGable predicates don’t get missing index requests. And that’s true! But can they also stifle my favorite thing to happen to SQL Server since, well, last week? You betcha!© One Sided I’m going to paste in some queries, each with something non-SARGable. There are two tables involved: Users and Posts. Only…

[Video] Office Hours 2017/04/19 (With Transcriptions)

Last Updated April 22, 2017

This week, Brent, Tara, Richie, and Erik discuss SQL Server 2017 CTP 2, quorum configuration for a 4-node availability group, database sharding, premature optimization, parameter sniffing, tracking query plans within cursors, and what’s coming up in the new version of Paste The Plan. Here’s the video on YouTube: You can register to attend next week’s Office Hours,…

SQL Server 2017: query_store_wait_stats

Last Updated May 12, 2017

Query Store (QDS), SQL Server 2017, Wait Stats

The missing link Back when the Query Store first got announced, I was amazed. The amount of information it gathered and persisted between reboots was such a big improvement over the plan cache, plus being able to force plans was really cool. I was always surprised that wait stats weren’t a part of that, especially…

[Video] Office Hours 2017/03/22 (With Transcriptions)

Last Updated March 27, 2017

This week, Tara, Erik, and Richie discuss statistics updates, in-place upgrades, row vs page compression, deadlocks, replacing SQL backup vendors, server load, ETL, and whether they think that database mail should be used by user applications to send their emails. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…

[Video] Office Hours 2017/02/15 (With Transcriptions)

Last Updated February 19, 2017

This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the…

Memory Grants and Data Size

Last Updated January 8, 2019

Execution Plans, Memory Grants, SQL Server

What does memory do? In SQL Server, just about everything. We cache our data and execution plans in it (along with some other system stuff), it gets used as scratch space for temporary objects, and of course queries use it for certain operations, most notably sorting and hashing. And of course, now Hekaton comes along…

High Compiles and Multi-Statement Table Valued Functions

Last Updated February 14, 2017

SQL Server, T-SQL, TempDB

Way back in 2016 I wrote about what to do if sp_BlitzFirst warns about high compiles. During GroupBy, Adam Machanic gave a great talk on new features in SQL Server 2016. It reminded me of a blog post I wanted to write about one common culprit of high compiles: Multi-Statement Table Valued Functions. Leaving aside…

Analyzing Temporary Stored Procedures with sp_BlitzCache

Last Updated November 16, 2017