Check the power plan that in use on Windows Server 2008 R2. The default power plan with a clean install of this OS is the Balanced plan. Using this plan (or other power-savings plans) can have a significant effect on Advantage Database Server performance. The negative performance impact seems to be even bigger when CPU utilization is low.
If you think this is the case:
Performance will, of course, vary in many different situations, but testing on one specific machine showed that the above changes (1 and 2) caused a test that appended records to run much faster. With all power management settings enabled, the test took 33 seconds to append 100,000 records. With the power management turned off, the same test ran in less than 7 seconds.
More details about this are in a Stackoverflow question.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
40 | |
25 | |
17 | |
14 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 |