AHAHAHA, Oh boy... So you won't believe this method to solve my problem
Hope this makes sense. So a little history, every now and then my wife accidently presses the power button not knowing I have it in a sleep state to turn the PC on, this error's the PC and displays a black screen instead of actually waking up forcing me to hold the power button down to manually shut it down and cycle reboot till it posts. When it eventually posts it brings up the boot screen with "overclock failed" and I have to reload the OC profile to carry on as normal.
So I got thinking, removing the CPU like
@Edwired suggested is kind of going to do the same thing, clearing the memory buffer and force me to reload the profile upon successful CPU install (not sure if clearing the CMOS is the same thing?) But anyways, forcing the overclock to fail and reload the profile did it for me and brought my DIMM's back to life and in full triple channel. The x58 platform really is like a classic car, sometimes you just need to thunk it good with a wrench and it'll do the trick.
Hope this helps some people, these are the additional settings I run within CPU configuration under Advanced in the BIOS:
*Note I have the C-states/tech disabled which likely allowed this error to happen for me
C1E Support: Disabled
Hardware Prefetcher: Enabled
Adjacent Cache Line Prefetch: Enabled
Ordering: Modern
Intel® Virtualization Tech: Disabled
CPU TM Function: Disabled
Execute Disable Bit: Disabled
Intel (R) HT Technology: Enabled
Active Processor Cores: All
A20M: Disabled
Intel (R) SpeedStep (TM) Tech: Disabled
Intel (R) C-STATE Tech: Disabled
View attachment 198708
View attachment 198709