To test whether the Amdahl LVS 4600 Storage System’s performance would degrade when I added workloads to other LUNs in the system, I used both single and multiple workloads. I set up a network to service a Microsoft SQL Server 7.0 application, a network to service a Microsoft Internet Information Services (IIS) 4.0 Web workload, and a network to service a file server. Table A details the performance test results.
Table A: Performance Test Results | ||||||||
Test Configuration | Workload | Metric | User Load | |||||
150 | 200 | 250 | 300 | 350 | 400 | |||
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0 | Transactions per second (tps) | 295.63 | 300.25 | 307.56 | 313.69 | 304.32 | 299.94 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0, Web Internet Information Services (IIS) 4.0, and file server | tps | 293.99 | 303.61 | 307.02 | 306.62 | 292.9 | 301.35 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0 | Bytes per second (bps): SQL log vol | 690,354 | 705,499 | 709,649 | 734,201 | 758,645 | 785,374 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0, Web IIS 4.0, and file server | bps: SQL log volume | 683,136 | 696,546 | 717,534 | 725,689 | 739,260 | 773,939 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0 | bps: SQL data volume | 2,106,728 | 2,134,548 | 2,147,940 | 2,179,598 | 2,193,648 | 2,229,589 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0, Web IIS 4.0, and file server | bps: SQL data volume | 2,097,884 | 2,123,582 | 2,165,972 | 2,158,814 | 2,181,157 | 2,199,596 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0 | Disk queue length: SQL log volume | 0.997 | 1.008 | 0.975 | 0.92 | 0.855 | 0.845 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0, Web IIS 4.0, and file server | Disk queue length: SQL log volume | 1.027 | 1.046 | 1.026 | 0.952 | 0.889 | 0.869 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0 | Disk queue length: SQL data volume | 128 | 135 | 181 | 186 | 186 | 188 |
Gateway ALR 9200, 22MB pagefile, 1GB RAM, no tables pinned | SQL Server 7.0, Web IIS 4.0, and file server | Disk queue length: SQL data volume | 130 | 163 | 182 | 183 | 190.583 | 158 |
0 comments
Hide comments