Threadmaster for SQL Server.

0 votes
asked by
edited by

I am running Windows Server 2003 Standard Edition r2 with SQL Server 2005. I need to use ThreadMaster to limit the CPU usage for sqlservr.exe. Could anyone tell me how to do it?

1 Answer

0 votes
No avatar answered by (3.7k points)
edited by

At first, you should make sure that you have installed Threadmaster on your system. On Windows 7, after you download the install package, you will very likely obtain an error when you try to install it into its default directory. Then you edit the "Install.cmd" file in Wordpad, for instance. On the fourth line of code, you should delete “zInstDir,” and instead, write the desired destination. Next, save the changes and run the .cmd file. Another important step that you should mind is to adjust the Registry before you open the application for the first time. In order to do this, you should run Regedit and access [HKEYLOCALMACHINE\SYSTEM\CurrentControlSet\Services\ThreadMaster\Parameters]. After you find the value “CPUThresholdPct,” you should define it as “100,″ so that ThreadMaster will throttle only when a program thread goes beyond 100% utilisation (i.e. - never). This acts as a global setting, so that if you do not wish its clamping to affect all applications, you should use the "blacklist" function in order to single out specific applications (e.g. your web browsers).

Following these steps, please configure MainSampleTime with the value of “10,″ which is the lowest possible. Thus, ThreadMaster will intervene after 10 seconds since an application will have passed its usage threshold. Under the "Applications" section from "Parameters," you are enabled to add programs that you wish ThreadMaster to specifically control. All you are required to achieve is to add the name of the executable or image file as a text entry, without its actual path. For the value of each entry, make sure you add the threshold for percentage of use that you wish to activate ThreadMaster's actions (a value between 5-20%, depending on the strength of your Central Processing Unit). After you finish configuring all these aspects, you may close the Registry and turn on ThreadMaster. Because its default setting is "Automatic," whenever Windows starts, so will this program.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...