dbTalk Databases Forums  

Question for Guru : Sybase IQ on external storage - dbspace sizing.

comp.databases.sybase comp.databases.sybase


Discuss Question for Guru : Sybase IQ on external storage - dbspace sizing. in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ilia Gulman
 
Posts: n/a

Default Question for Guru : Sybase IQ on external storage - dbspace sizing. - 03-02-2004 , 09:29 AM






Hi,

This may be a litle bit complex question:

We have sybase IQ running on Solaris with external EMC storage,
with one huge raid 5 dimention of space.
Now we need to create an IQ database sized 3TB.

There are 2 alternatives to do it:
1) To create one dbspace sized 3TB, on the raid dimension defined with
veritas volume manager on the storage.
* This solution is based on several sybase IQ recomendations to create
as few dbspaces as possible.

2) To divide the 3TB to X raw partitions (with vol. manager), so that
X will be equal to the number of physical disks dedicated to the
particular raid.
* From my experience, this recomendation would be good for ASE,
espesially for parallel query processing.

In other words, will sybase IQ do enough parallel IO operations, to
use the storage parallel capabilities, if it has no Idea of the
underling hardware ?

I will be really gracefull for any help.

Regards,
Ilia.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.