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

Here are the additional findings hope someone have more inputs. High CPU during this period only a front application reboot will resolve. There are alot connections but do not see...

How about query time-out to exit the query when it has been executed over default 10 minutes to unlimited 0?

Thanks guys! We noticed this issue again. So this time I did not restart the database server at all and instead advised to restart application servers only and everything came...

Adding more info! Hoping someone has any thoughts? Here is what I have outlined you for a 3- node cluster for read-only routing for AOAG. Do you see any issues...

To add to it. How about scale out option?

Thanks. Any thoughts on this?

I ran into a latch timeout issue and followed this instruction and went through the steps and got below stack. It is slightly different. Any advise?

https://mssqlwiki.com/2012/09/07/latch-timeout-and-sql-server-latch/

Call Site

00 KERNELBASE!RaiseException

01...

Is it good to run every 15 mins?

If I have more than 50 servers do i need to create the Job in all 50 servers?

Ok. Another finding from me is i found the update query in the dump.txt file which seems to be human readable. But going back to queries during the CPU spike ...

Thanks. Sorry for shifting the gears. I installed the tool to read the dump file and would it be okay to read from the server or copy the dmp files...

So alerting for stack dumps is not possible?

Thanks for the response. In my case the system was up and running after the stack dumps were generated so SQL service was never went down. Only symptom was spike...

Thanks Brian. To identify the stack dump issue quicker. Is there a way to configure alerts when this happens?