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
2.OLTP Server Jrun/JSP serverlet,SQL2K, IIS, two application databases of 0.5 to 2GB
3.OLTP Server ASP/COM/ISS/SQL2000/ three application databases of 2-4GB
4. ETL server Yet to be added to the production environment
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access