This paper demonstrates the performance benefits that IBM® Easy Tier™ provides by seamlessly migrating hot extents from hard disk drives (HDDs) to a higher performing solid-state drives within theIBM Storwize V7000 solution.
This might be either to internal solid-state drives in the IBM Storwize V7000or to external storage systems that are virtualized by IBM Storwize V7000.
The other load generator tool that has been used here is Oracle Vdbench. The objective of Vdbench is togenerate a wide variety of controlled storage I/O workloads, allowing control over workload parameterssuch as I/O rate, logical unit number (LUN) or file sizes, transfer sizes, thread count, volume count,volume skew, read/write ratios, read and write cache hit percentages, and random or sequentialworkloads.
The other load generator used to arrive at the configuration guidelines is the Oracle I/O Calibration ToolORION) calibration tool.
This tool generates I/O using the same I/O software stack used by the Oracle server software without having to install the server software and create a database. It can simulatevarious workload types at different load levels to arrive at performance metrics for input/output operationsper second (IOPS), and latency (response time). It can also simulate the effect of striping performed byAutomatic Storage management (ASM).
The intention of this paper is not to demonstrate the maximum possible I/O benchmark or performancenumber for the IBM Storwize V7000. Those benchmark and performance numbers are likely to be shownin the Storage Performance Council SPC-1 and SPC-2 results posted by IBM on the SPC website. Thispaper demonstrates how to configure Easy Tier, and explains how Easy Tier might benefit theperformance for an Oracle database workload by optimizing the utilization of solid-state drives.
See link below…
This paper discusses some guidelines for administering space usage for Oracle Automatic Storage Management (ASM) on the IBM® System Storage™ SAN Volume Controller (SVC). The back-end storage controller used with SVC is the IBM System Storage DS8000®.
The discussion includes scenarios which show the tasks necessary for space administration in a checklist format. The scenarios presented assume that space administration is occurring during periods of high storage I/O activity. Therefore, a freely available Oracle load generator, Swingbench, is used to generate a heavy I/O workload during the exercises.
The subjects covered include:
• A brief overview of the hardware and software technology stack used for the scenarios.This includes the IBM SVC, the IBM System Storage DS8000, the IBM System Storage SAN32B-3 Fibre Channel switch (also known as the IBM Brocade 2005-B5K or Brocade 5000), Oracle 11g ASM, the Red Hat Enterprise Linux 5.3 and IBM AIX 6.1 operating systems, and IBM TotalStorage® Productivity Center (TPC) 3.3.2.
• A detailed description of the usage of the Swingbench Oracle load generator, including how to configure Swingbench to generate as much storage I/O as possible.
• Basic space administration tasks for the IBM SAN Volume Controller (SVC). • Basic space administration tasks for Oracle Automatic Storage Management (ASM).
• Typical space addition scenarios for Oracle ASM on SVC. Two scenarios will be discussed, adding an ASM disk to an existing ASM diskgroup and expanding existing ASM disks in a diskgroup.
• Typical space reduction scenarios for Oracle ASM on SVC. Two scenarios are discussed, removing an ASM disk from an existing ASM diskgroup and shrinking existing ASM disks in a diskgroup.
• A scenario where an MDisk is added to an SVC MDisk Group containing the database. The VDisk extents on that MDisk Group are then rebalanced across all of the MDisks now contained in the MDisk Group.
• A scenario where all of the VDisks which contain the database, including the OCR and Vote disks, are non-disruptively migrated to a different MDisk Group via the “svctask migratevdisk …” command. This could be used to migrate the database to different back-end storage controller.
• A scenario where all of the VDisks which contain the database, including the OCR and Vote disks, are non-disruptively migrated to a different MDisk Group via VDisk mirroring. The VDisks are mirrored and after the mirror is synchronized the original copies of the VDisks are deleted. Again, this could be used to migrate the database to a different back-end storage controller.
• Some basic SVC CLI (Command Line Interface) and Oracle SQL*Plus scripts that can be used for SVC and ASM space administration and monitoring.
See link below