Continue in 2 seconds

We have a consumer base data mart running on Win2K/SQL2K(SE) with MicroStrategy as the BI tool.

Published
  • August 04 2003, 1:00am EDT

Q:

We have a consumer base data mart running on win2K/SQL2K(SE) with MicroStrategy as the BI tool. The architecture is as follows:

1. OLAP Server – MSTR WebIntelligence, OLAP Meta data/data marts/SQL2000/one database of 4GB
Server HW: Compaq ML350G2,2GB, Dual PIII 1.26GHz

2.OLTP Server – Jrun/JSP serverlet,SQL2K, IIS, two application databases of 0.5 to 2GB
Server HW – Compaq ML350G2, 1GB, Dual PIII 1.44GHz

3.OLTP Server – ASP/COM/ISS/SQL2000/ three application databases of 2-4GB
Server HW: Compaq ML350G2,1GB,Dual PIII 550MHz

4. ETL server – Yet to be added to the production environment
Server HW: Compaq, 1GB, 1x P4 2.2GHz

A:

Sid Adelman’s Answer: I’m just going to answer #3. Your problem may not be the architecture. You need to have a way to measure what’s going on in the box and in the databases. You need to look at what’s generated in the queries and how those queries are rambling through the databases. You may find the access paths are inefficient, generating far more I/Os and using far more machine cycles than are necessary. Very often the database design is inappropriate for the types of accesses your users are creating.

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