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

Testing IO Accelerator-powered SQL performance 10

Physical Disk—Average Disk queue Length

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

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

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

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

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

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

o Logical Disk—% Disk Read Time

o Logical Disk—% Disk Write Time

o Logical Disk—% Disk Time

o Logical Disk—% Idle Time

o Logical Disk—Average Disk Read Queue Length

o Logical Disk—Average Disk Write Queue Length

o Logical Disk—Average Disk queue Length

These data points provide information on how your SQL Server is performing.

If you cannot restore your entire database, you can evaluate performance by creating a sample database

and doing the following:

• Conduct index maintenance.

• Conduct DBCC maintenance.

• Conduct full backups.

• Conduct full restores.

• Monitor the PERFMON counters previously stated while these operations occur. The counters provide

a profile of your SQL Server performance.

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

Brak uwag

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