Recent content by ray2

  1. R

    quad datawarehouse server

    We want to atleast half our datawarehouse query time. if we succeed we replicate the same database config on our other 4 cpu databasewarehouse. i have been unable to reach my $60K budget for doubling my datawarehouse performance since last six months and I am loosing patience. I got quad...
  2. R

    quad datawarehouse server

    why only comparison between dual opteron and dual xeon. what about dual power5 and dual itanium 2? because our datawarehouse environment is 20 fold bigger and we run 4 cpu xeon MP 3.0 Ghz and we looking for doubling our performance for $50K budget. We have 60 disks 73 GB 10k rpm fibre...
  3. R

    Shared disk V/s shared nothing.

    shared disks seems to be the norm for OLTP clusters. shared nothing seems to be the norm for DSS clusters. What happens in the time of mixed workload? How you draw a boundary line between few clusters of SMP's ( 4-8-16 cpu machines ) and lots of clusters of 2 cpu machines ( like...
  4. R

    processor caches and memory bandwidth

    what is the difference between front side bus bandwidth and memory bandwidth within the processor. how much of an impact is that on performance. also how much of an impact is increasing L1, L2, L3 cache on performance.