So, probably not going to have a single book that explains "each topic in full depth".

I have two books that I've written, totaling about 1,300 pages between the two of...

It can be a weird line here.

At my previous job, we were moving our entire data center from one building to another. As part of it, we wanted to, just...

The lack of a response is pretty sus too.

Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be what you...

This...

Yeah, it's as @Ant-Green has it. You have to have the live data window open first. It only shows active events. However, you can directly open the file, and it...

A whole bunch more functionality available in Extended Events. Here's a blog post showing how to use them to troubleshoot timeouts. There's also other events mentioned in the post...

Just realized this is a six year old post. I still stand by what I said though.

Extended Events!

I know, I know. It's sometimes all I talk about.

The issue is simple. Extended Events, the core underlying architecture, is pretty amazing and clearly used by all the different...

Here's an example. Probably best to trim some of the events away, and obviously you'll want a different set of filter criteria.

Extended Events, with causality tracking, can show you exactly when & how statistics get updated.

You've got the basics mostly right. Async updates will occur after, not query execution, but after the compile process is complete. This is why, you may still see almost instantaneous...

As Jeff says, I've learned not to argue with him, you can do it all in SQL Server. I've had bad experiences though.

So, yeah, you could do any combination of...

Connection settings, others. It's something.

I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two different...