Results 1 to 12 of 12
  1. #1
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Question Unanswered: Best Enterprise Datawarehouse

    We currently run a MASSIVE enterprise data warehouse on SQL Server 2000 and it is struggling a bit with both user queries and daily loads.

    Need opinions on

    1. Is SQL Server the best product for the job
    2. What are the alternatives

    Cheers

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is massive ? Also, what is your hardware specs ?

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    And what are you doing with it? Are you creating cubes off of it?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  4. #4
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    Have about 7 + Terabytes of data - growing at 100 gb a month

    Team of dedicated App Dev staff designing and developing OLAP cubes and publishing on the intranet using third party software

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    What type of cubes ? What version of sql are you using ?

  6. #6
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    What window do you have available to perform the daily loads? Approx how long does each load take?

  7. #7
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    At that size I am sure MS would love to help you (and use you in their marketing )
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can easily deploy SQL Analaysis Services in this case, check ver 2000 for more enhancements and information on MS SQL homepage.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  9. #9
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    No one seems to have opinions on any other products other than SQL Server? I guess it is a SQL Server forum but like I have already said - this is our current platform and is Struggling !!!!

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by aldo_2003
    Have about 7 + Terabytes of data - growing at 100 gb a month

    Team of dedicated App Dev staff designing and developing OLAP cubes and publishing on the intranet using third party software
    Gotta ask....what's the subject of the data?

    3rd party software?

    I don't think (damn it, again) that ANY 3rd party software plans for anything that massive...

    And EVERYONE is writting adhoc queries...right?

    "This sounds like a job for "Super-Silver bullet""

    And yes, MS would love to talk to you.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  11. #11
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Lightbulb

    Originally posted by aldo_2003
    No one seems to have opinions on any other products other than SQL Server? I guess it is a SQL Server forum but like I have already said - this is our current platform and is Struggling !!!!
    Be happy using Sybase IQ !
    => T-SQL compliance
    => DSS database
    => performance++

  12. #12
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    You have given very few information regarding your environment and the reasons you are struggling, other blaming SQL. We would be glad to help you if you could tell us more about your data warehouse. So we can see where your bottleneck is. But if you are looking for the answer of 'Yes, you need to switch to O..... and S.. platform', please go to O..... forum. Thanks.

Posting Permissions

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