Thanks everyone for the feedback so far. All jives with my understanding. I've just never heard the phrase "healthy deadlocks" before, so I was curious what others thought.

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement:

Some deadlocks are healthy.

or

Some level of deadlocks is healthy.

Or is more something like:

Some level...

Backups should be run serially. I tried running them in parallel. It's a great way to bring down a server. So yes, most tools, software and suggested solutions, show backing...

If you're just looking at hosting a container, all the cloud vendors do it. Amazon ECS is one option. Azure Container Hosting is another. Pricing-wise, they're pretty similar. Better to...

If you're looking for truly legit certification courses, I'd suggest starting with Microsoft. There, they list a bunch of partners that offer up-to-date training. If you want online, Pluralsight...

What did you do?

Just so someone who finds your question also knows the answer.

If it makes you feel better 19 (in beta) isn't installing very quickly either.

It's all about the fundamentals. If every single thing is equal, so should performance be. So things are not equal. It's a question of walking through and figuring it out.

First...

Everything Jeff said.

But, one exception, columnstore indexes. Reorganization and rebuild do things...

On the missing index views? They just don't say anything. I'm not talking about all the other DMVs. They're vital. 1 million percent so. But the...

On the missing index views? They just don't say anything. I'm not talking about all the other DMVs. They're vital. 1 million percent so. But the missing index...

On the missing index views? They just don't say anything. I'm not talking about all the other DMVs. They're vital. 1 million percent so. But the missing index DMVs? Useless...

I like the answer from @DNA_DBA. That's a great approach. To that I would add, query the cache to see what kind of queries are being run on the system....

Generally speaking, the missing index recommendations taken from the DMV tables are useless. That's because they are not, and cannot be, linked to a given query. So you just have...

I've seen no types of standard degradation between 2017 and 2019. So, I'd suggest examining all the server settings, cost threshold, the things already suggested here.