Faeandar
Guest
|
 Posted:
Wed Nov 10, 2004 6:55 am Post subject:
Re: Application benchmarking and specifiying storage require |
|
|
On 8 Nov 2004 14:43:34 -0800, strepxe@yahoo.co.uk (championsleeper)
wrote:
| Quote: | We have an application which is based around an oracle database and
processes 100's millions of records per day. A number of tables in the
oracle database are hit very hard, with reads and writes to a set of
tables occuring on a near-random basis (dictated by the data
received). I'm in the situation where I'm trying to develop a
benchmarking exercise to understand the requirements of the system in
terms of i/o as it's the bottleneck in the system.
- Can anyone suggest how I might understand the i/o requirements for
the different tablespaces and/or tables in the database per unit time?
- What kind of information do storage engineers need to configure
their array to meeet application i/o requirements?
|
Well, first question is what is this running on today? Does it have
any monitoring/reporting tools built-in? Alot of storage arrays and
appliances can give you at least some rudimentary idea of where
bottlenecks and high traffic areas are.
Second (and this is where I show my ignorance for databases) , can the
tablespaces be specificall placed? As in some tablespace1 goes on
this lun/fs, tablespace2 goes on this lun/fs, etc.?
~F |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in