Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    1

    Question Unanswered: How to setup IQ with SSD

    Could someone advise on how to use effectively SSD storage with IQ 15 for the following resources.

    16 cores server running RHEL 6.2.
    256GB of RAM
    20TB of FC SAN.
    1.2TB of FusionIO SSD.

    Our shop have used so far Oracle and we were using the 2nd level Flash cache feature and the user temp tablespace on SSD. This was giving us very good performance without to worry about running out of SSD space.

    Now, we are experimenting with Sybase IQ and we would like to do something similar. We are also thinking to use FusioIO Direct Cache kernel module. We do not want to move data around every night from SSD to SAN as aging strategy.

    Please advise.

    Thanks,
    Mantrix

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Mantrix,
    Sugestion IQ conf ( .cfg file ):
    #######################################
    ###### 1GB of mem left for Rhel ###############
    ###### 20% for fylesystem cache = 52224 = 51 GB ###
    ###### ratio 40-60 mem 104bg ################

    #Main cache = 82gb
    -iqmc 83558

    #Temp cache = 122gb
    -iqtc 125338

    #Number of cpus = 16;
    -iqnumbercpus 16;

    ##################end###################

    Sybase IQ is cpu bound, so it uses the cpus and temp cache to run queries before it goes to TEMP IQ Store, of course having this on the SSDs will enhance the performance if your DB is DSS.
    If your DB is OLTP, has a lot of writing and reading from disk, it wont have much impact the use of SSDs (on TEMP IQ STORE), because they wont be used, only the SAN...

    Also check the query plan of your queries, you may need to force parallelism, so that the optimizer takes the most of your cpus.
    You can use MINIMIZE_STORAGE = on to minimize disk space.
    Index advisor = on , gives you advices to what index to use, rebuild.... based on your queries, good for tunning.

    Regards.
    Last edited by Catarrunas; 01-03-12 at 14:04.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •