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...

I am not an Azure Analysis Services expert by any means. However, Azure SQL Database, I believe part of the underlying architecture, doesn't support Profiler/Trace. Instead, you must use Extended...

In a key lookup operation, what's being looked up is not the key value, but other values. The clustered key value is actually already a part of the nonclustered index....

Check out the ISNUMERIC() function. That will tell you what you want to know.

Strong advice: all tables, all databases, all the time, use appropriate data types. It really matters.