Avg CPU NA 52.5% 43.9% 37.7% 31.2% WFE-3 Available NA 6,124 6,008 5,940 6,227 RAM WFE-3 Avg CPU NA NA 44.5% 34.8% 34.7% WFE-4 Available NA NA 6,068 6,083 6,359 RAM WFE-4 NA NA NA 35.1% 32% Avg CPU WFE-5 Available NA NA NA 6,090 6,245 RAM WFE-5 Avg CPU NA NA NA NA 33.9% WFE-6 Available NA NA NA NA 5,893 RAM WFE-6 Avg CPU 2.13% 1.93% 2.54% 2.48% 2.5% PACNEC01 Available 899,970 815,502 397,803 397,960 397,557 RAM PACNEC01 9.77% 11.7% 15% 14.7% 13.6% Avg CPU APP-1 Available 14,412 13,990 14,230 14,227 14,191 RAM APP-1 Avg CPU 1.06% 0.92% 1% 1% 1.04% APP-2 Available 14,928 14,841 14,874 14,879 14,869 RAM APP-2 Table - Detailed Results from Series E Testing Test Series F Vary SQL Server CPUs – In this test series we vary the number of CPUs available to SQL Server. Figure - Average RPS for series F You can see in Figure 28 that despite minimal CPU use on the SQL Server computer, the page and transaction response times go up when SQL Server has fewer CPUs available to work with. Figure - Page and transaction time for series F In Figure 29 the SQL Server average CPU for the whole computer does not go over 3%. The three front-end Web servers are all around 55% throughout the tests. Figure - Average CPU for series F
Avg CPU WFE-3 NA 52.5% 43.9% 37.7% 31.2% Available RAM WFE-3 NA 6,124 6,008 5,940 6,227 Avg CPU WFE-4 NA NA 44.5% 34.8% 34.7% Available RAM WFE-4 NA NA 6,068 6,083 6,359 Avg CPU WFE-5 NA NA NA 35.1% 32% Available RAM WFE-5 NA NA NA 6,090 6,245 Avg CPU WFE-6 NA NA NA NA 33.9% Available RAM WFE-6 NA NA NA NA 5,893 Avg CPU PACNEC01 2.13% 1.93% 2.54% 2.48% 2.5% Available RAM PACNEC01 899,970 815,502 397,803 397,960 397,557 Avg CPU APP-1 9.77% 11.7% 15% 14.7% 13.6% Available RAM APP-1 14,412 13,990 14,230 14,227 14,191 Avg CPU APP-2 1.06% 0.92% 1% 1% 1.04% Available RAM APP-2 14,928 14,841 14,874 14,879 14,869 Table - Detailed Results from Series E Testing Test Series F – Vary SQL Server CPUs In this test series we vary the number of CPUs available to SQL Server. Figure - Average RPS for series F You can see in Figure 28 that despite minimal CPU use on the SQL Server computer, the page and transaction response times go up when SQL Server has fewer CPUs available to work with. Figure - Page and transaction time for series F In Figure 29 the SQL Server average CPU for the whole computer does not go over 3%. The three front-end Web servers are all around 55% throughout the tests. Figure - Average CPU for series F
scalability-test-lab-report.docx