SQL error
1. “Cannot load Counter Name data because an invalid index” When trying to install SQL2019 PolyBase (and possibly other programs as well), you may receive error “Cannot load Counter Name data because an invalid index” exception
To fix this error, start CMD as administrator and run
C:\WINDOWS\System32> lodctr /r then run
C:\WINDOWS\SysWOW64> lodctr /r If all success, you should receive message: “Info: Successfully rebuilt performance counter setting from system backup store”
Posted by John Liu Thursday, November 25, 2021