Using Indexing to Improve Query Performance




Download 1.5 Mb.
bet15/218
Sana21.03.2017
Hajmi1.5 Mb.
#1065
1   ...   11   12   13   14   15   16   17   18   ...   218

Minimum and Maximum Processor Performance State


Processors change between performance states (“P-states”) very quickly to match supply to demand, delivering performance where necessary and saving energy when possible. If your server has specific high-performance or minimum-power-consumption requirements, you might consider configuring the Minimum Processor Performance State parameter or the Maximum Processor Performance State parameter.

The values for the Minimum and Maximum Processor Performance State parameters are expressed as a percentage of maximum processor frequency, with a value in the range 0 – 100.

If your server requires ultra-low latency, invariant CPU frequency, or the highest performance levels, you might not want the processors switching to lower-performance states. For such a server, you can cap the minimum processor performance state at 100 percent by using the following commands:

Powercfg -setacvalueindex scheme_current sub_processor PROCTHROTTLEMIN 100

Powercfg -setactive scheme_current
If your server requires lower energy consumption, you might want to cap the processor performance state at a percentage of maximum. For example, you can restrict the processor to 75 percent of its maximum frequency by using the following commands:

Powercfg -setacvalueindex scheme_current sub_processor PROCTHROTTLEMAX 75

Powercfg -setactive scheme_current
Note   Capping processor performance at a percentage of maximum requires processor support. Check the processor documentation to determine whether such support exists, or view the Perfmon counter “% of maximum frequency” in the Processor group to see if any frequency caps were applied.



Download 1.5 Mb.
1   ...   11   12   13   14   15   16   17   18   ...   218




Download 1.5 Mb.

Bosh sahifa
Aloqalar

    Bosh sahifa



Using Indexing to Improve Query Performance

Download 1.5 Mb.