Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle
2006-09-14 11:24:01
On Sep 14, 2006, at 10:59 AM, Bernaldo de Quiros, Iban 1 wrote:
Hi Richard,
There's a lot of great stuff here and good advices !!
But I have two last questions...
1-Will you share the same physical disk with database and storage
pool ¿?
Never mix conflicting access-pattern subsystems in storage areas -
that can be as bad as tape and disk on the same I/O path. It is
essential that your database be as high-performance as possible, so
keep it separate.
2-Will you spread database volumes over the same physical disk or
over different physical disks ¿? Or will you make both ¿?
In a non-RAID environment, I would spread over physical disks, to the
extent reasonable. If very large disks, you may want a few
partitions on the disk; but then try to use 15,000 rpm disks. But I
prefer using raw logical volumes and hardware RAID 1+0 (striping and
mirroring) for best performance. And beyond that there are
sophisticated disk subsystems out there which offer further
opportunities. Remember that TSM uses one thread per disk volume, so
you gain by having a reasonable number of volumes.
Look back in the List archives for information posted from the hard-
won experiences of other contributors, as there's lots of good advice
in our collective efforts.
Richard Sims
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle,
Richard Sims <=
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Ford, Phillip
- Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Leigh Reed
|
Previous by Date: |
Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1 |
Next by Date: |
Re: TSM 5.3 Extended Edition Contents, Prather, Wanda |
Previous by Thread: |
Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1 |
Next by Thread: |
Re: Best Practices DISK for DB, LOG, and STGPOOL && JigSaw Puzzle, Bernaldo de Quiros, Iban 1 |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|