We have just kicked off our data warehouse project, and I'd like to know where I can get information about the performance comparison between SQL Server and ShowCase's Strategy, because one of these two platforms will be our choice for the DW. We are a multiple AS/400 shop, having over $1 billion sales per year. Can you give me any hints to help us to choose?


Sid Adelman’s Answer: Ask the vendors for references with large databases with significant query and reporting activity. Talk to the references about their performance. Find out what they are experiencing. If they have any monitors that give them hard numbers, you should be able to make some comparisons. If they can't give you references with, at least, your estimated size and estimated number of users, be very wary.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access