I'm running the latest sp_Blitz script on a SQL 2016 Std server on a Windows Server 2016 physical box. I'm getting the following error. What could be causing this and how do I troubleshoot it?
RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.' Msg 22001, Level 1, State 1 Warning: Null value is eliminated by an aggregate or other SET operation. Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
sp_Blitz
usesxp_regread
for two things: to check processor speed and to look for stacked instances. In order to figure out which check this fails on (assuming either one is critical to your health check) you'd need to run Blitz with@Debug = 1
and report back. – Erik Darling Apr 8 at 2:34xp_regread
to look at power settings. And based on Brent's answer/guess, that might be the one that is failing. I think it needs to check the non-GPO registry key (CurrentControlSet blah blah blah) if theSOFTWARE\Policies\Microsoft\Power\PowerSettings
one is missing. I'll see if I can code up a fix and submit it. – Doug Deden 2 days ago