Good to hear Lynn. I mean the job thing. Of course I also get excited about selling Redgate software too.

Makes sense.

Yeow!

That's like all the problems.

When I consult on this stuff, the one strong recommendation I make is to get champions at multiple levels on multiple teams. If there are people...

You have to look to multiple metrics. The plan is one, certainly, but after that you look to I/O, CPU, memory, blocked processes, waits.

It would be easier to give a complete answer with the Profiler events and filter. However, on a guess, the process id changed? They're not always the same. If a...

Nah, the plan can be the same for lots of different executions. If it doesn't recompile, regardless of parameters passed, you'll see the same plan used over & over. It's...

So, a hardware change and then behavior changed? When you say right before, you mean several days, several hours, or they pretty much coincide?

We had the experience once where backups slowed down and the problem was a switch going bad. It didn't evidence itself for any other process except our SQL Server backups....

And to understand the performance degradation, capture the execution plan of the query, once when it's running well, and once when it's running badly. Compare those to understand the changes....

Are you backing up to the same disk where all the data is? Are you backing up to the disk where the OS or is? Are you backing up across...

In the end, most SQL Server problems come down to the queries. I'd suggest setting up some kind of query monitoring. Since you're posting in the 2019 forum, the best...

To my knowledge, the only book specifically on this topic was written back in 2008 or so (looking it up, seems the book got updated in 2012). However,

Oh please. We don't have to list all the times we screwed up do we? My list is going to take a long time to compile. I think I'll have...

Grant - its likely to be Solar EMP rather than Solar Radiation - look up carrington event.

.. and the Sun HAS been behaving in an unpredictable manner this Solar...

Thanks.  Can you comment on Query store, Forced a good plan with query store and left query store on to capture all. So far the server is operating well....