Piling on because this is a serious topic.

First, yes, using READ UNCOMMITTED is actually a much better choice than painting your code in NOLOCK hints.

Next, the fact is, reading uncommitted...

And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No real information...

Sure thing. And since you're just getting started in the wide world of query tuning, I'd suggest getting copies of my books (one is free in digital mode). Also a...

Without a lot more details, it's really hard to say what could be the cause. Sounds like the application server is doing something funky which results in excess CPU use....

Thanks for your feedback Grant, and for confirming my suspicion. I was noticing the many many duplicate suggestions and thought it seemed extremely generic in nature. It seems it...

Good catch.

Yep. Impossible. You simply can't combine database management systems in this way. They're not compatible. To solve a problem like this, you'd need to create some type of service to...

The Database Tuning Advisor is an actively dangerous tool to use. It makes a lot of recommendations. Most of the time, they're useless. You can see right there in the...

Hmmm... Sorry. I can't think of anything else it could be. A backup includes Query Store and there's no step you have to do or command or anything. It's just...

Everything that Jeff says, plus, under resourced servers, network configuration issues, and a whole slew of other system, network, OS, or server configuration issues. Just based on the information, "things...

If Query Store is enabled on a given database, when that database gets backed up, the information within Query Store will also be backed up. No extra steps are necessary...

Although, we do have a MySQL forum. It doesn't get much love though. I'd post any further MySQL questions there. You're more likely to get people who know about...

The only way to make a query without any filtering run faster is by purchasing bigger, faster, hardware. There's no magic that can be done when you move everything. Jeff's...

The plan didn't upload, so it's going to be really hard to make a suggestion without the plan or the query.

Obviously I agree with that principle, as a general rule. Would you say...