HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Pobierz pdf (Strona 9)

Testing IO Accelerator-powered SQL performance 9

Testing IO Accelerator-powered SQL

performance

Methodology

Generally, benchmarks such as SQLIO and ioMeter are used to measure the I/O profile of the storage

sub-systems. However, with IO Accelerators, these tests often give false results since the tests were

designed for measuring spinning disk media and do not completely provide the performance of the IO

Accelerators.

Workload examples

HP recommends that you use a realistic a load when testing the IO Accelerator-powered SQL Server. For

example:

1. Restore a copy of the production database onto the test IO Accelerator server.

2. Create a profiler trace on the production server for approximately one hour.

3. Replay this trace on the test server.

For the baseline from production and the baseline from test, perform the following steps:

1. Calculate the average duration for SQL Statements completed using the SQL Profiler.

2. Observe the following counters using PERFMON:

o Processor ——% Processor Time

o Paging file—% Usage [Page file Activity]

o SQLServer:Databases—Data File(s) size (kb) [Database Activity for tempdb]

o SQLServer:Databases—Log File(s) size (kb) [Database Activity for tempdb]

o Physical Disk—Avg. Disk sec/Read [Read Latency]

o Physical Disk—Avg. Disk sec/Write [Write Latency]

o Physical Disk—Disk Reads/sec [Read IOPS]

o Physical Disk—Disk Writes/sec [Write IOPS]

o Physical Disk—Disk Read Bytes/sec [Read throughput]

o Physical Disk—Disk Write Bytes/sec [Write throughput]

o Physical Disk—% Disk Read Time

o Physical Disk—% Disk Write Time

o Physical Disk—% Disk Time

o Physical Disk—% Idle Time

o Physical Disk—Average Disk Read Queue Length

o Physical Disk—Average Disk Write Queue Length

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Brak uwag

HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Strona 9