Shulou(Shulou.com)05/31 Report--

SQL Server 2008 installation can not be solved through the performance counter consistency, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.

During the SQLServer2008 installation, there is a problem with the operating system timer, which needs to be manually regenerated from the basic performance counter library in order to solve the problem.

How can SQLServer2008 installation be solved through performance counter consistency?

Do the following:

Find the "Perfc009.dat" file and "Perfh009.dat" file from the operating system installation disk, or from the system32 of another good machine, and copy it.

Start Registry Editor and look for the following key in the registry: HKEY_LOCAL_MACHINE\ Software\ Microsoft\ WindowsNT\ CurrentVersion\ Perflib.

If you copied the above two files from another machine, open the registry and write down the value of "LastCounter" (decimal) and "LastHelp" (decimal). Copied directly from the system installation disk (recording LastCounter:1846 and LastHelp:1847 directly) and then in the same location on the problem machine, modify the values of these two items to the previously recorded values. And overwrite two files with the same name under system32.

Look for the following registry key to search for services with Performance subkeys: HKEY_LOCAL_MACHINE\ System\ CurrentControlSet\ Services, and remove the following values from the Performance subkey:

How can SQLServer2008 installation be solved through performance counter consistency?

FirstCounter

FirstHelp

LastCounter

LastHelp

There may also be no Performance subkey, if so, never mind.

After you complete this process, you must re-add extensible counters from the list of services. The specific operations are as follows:

Open a command prompt window.

At the command prompt, type cd%Systemroot%\ System32 to jump to the system32 directory.

At the command prompt, type findstrdrivername*.ini to display the names of all timing-related ini files.

Notice the .ini file name for each driver name in the list.

At the command prompt, type the following line, where lodctrinifile, where inifile is the .ini file name of the driver you want to reload.

Repeat step 5 for all .ini files in the list.

Restart the computer.

Reinstall SQLServer2008 and the problem can be solved.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.