I attempted to install the latest CU (31) for my SQL 2017 server but received an error message stating "Service Pack Failure: MissingRegistryKeyException" due to a missing registry key. It appears that our SQL server is missing certain performance counters as I was only able to retrieve 57 row records after executing the command "select * from sys.dm_os_performance_counters order by object_name". I have tried to restore the SQL Server performance counter by running the command "lodctr perf-MSSQLSERVERsqlctr.ini", but the command failed due to the absence of the "perf-MSSQLSERVERsqlctr.ini" file. How can I recover this file?
You could try Maintenance => Repair in the installation center