Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
My guess is that it's related to this Github issue. Another user reported it, but because I can't quickly reproduce it, and the reporting user didn't want to submit code to fix it, we ended up closing the issue.
If you'd like to help troubleshoot and fix that issue, you can make notes in that Github issue, and use the First Responder Kit's Contributing Guide to get started with the code.
sp_Blitzusesxp_regreadfor 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 = 1and report back. – Erik Darling Apr 8 at 2:34xp_regreadto 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\PowerSettingsone is missing. I'll see if I can code up a fix and submit it. – Doug Deden Apr 8 at 21:52