RE: performance diff if move 1 of several app data libs to asp 2

It really depends on the disk controller, number of drives, drive types and speed, and size of drives.

4 2T SATA drives at 7200RPM will be slow compared to 8 320GB 15K RPM SAS drives. SCSI performance can really slow things down compared to SAS.

Most Archive ASP's I have seen have been of few large slow drives to hold lots of rarely used data. Would not put prod DB's there.

Chris Bipes
Director of Information Services
CrossCheck, Inc.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of J Franz
Sent: Wednesday, March 12, 2014 1:03 PM
To: Midrange Systems Technical Discussion
Subject: performance diff if move 1 of several app data libs to asp 2

We want to balance our asps so asp 1 not so full, but don't want performance degraded.
If moved, user apps will be reading data from both asps. Asp 2 was orig set up years ago for old rarely used data.
 
--Auxiliary storage pools--   Over-       -----  ASP Media  -----
Name      Number   Type       flow Mirror   Size    Avail   %Used
*SYSTEM    00001 *SYSBAS       No   No      1835 G 206283 M  88.7
*NONE      00002 *SYSBAS       No   No    705650 M 222931 M  68.4
 
Inquiring minds want to know...