SQLPrompt from Redgate
proved useful
Erik Darling has built two new procedures; sp_LogHunter and sp_HealthParser. I’ve tried both, and found one server that had core dumped without anyone noticing (using sp_LogHunter).
sp_HealthParser crashed on me, because Last_Execution_time was way before Creation_time. How is that possible?
I think both go into my toolbox for future use.
Find them at https://lnkd.in/eNDXy9cq and https://lnkd.in/eeC2BnYe