Barcelona march 2005 international sales services meeting
Download
1 / 18

Barcelona – March 2005 International Sales & Services Meeting - PowerPoint PPT Presentation


  • 93 Views
  • Uploaded on

Barcelona – March 2005 International Sales & Services Meeting. Technical Overview. The Structure. Everest - Bpm Unified Solution. The Structure. Business Logic SQL Server 2000. Strong benefit to have the RDMS tightly integrated with MOLAP (Analysis Services)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Barcelona – March 2005 International Sales & Services Meeting' - debbie


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Barcelona march 2005 international sales services meeting
Barcelona – March 2005 International Sales & Services Meeting

Technical Overview


The Structure

Everest - Bpm Unified Solution


The Structure

Business Logic

SQL Server 2000

  • Strong benefit to have the RDMS tightly integrated with MOLAP (Analysis Services)

  • Using this open technology we can use backup procedure, jobs, log files and all features related to SQL 2000

  • Three-tier architecture is fully supported


Database server (SQL server)

Analysis Services Server (OLAP server)

File Server (Web-folders)

Web Server (Applications servers)

Type of service


SQL server database

No components installed on this level

Store data

Good maintenance of SQL database is doing the performances to be high

Software required SQL server (Enterprise Edition not required)

DataBase


Multidimensional database; at this level we are keeping the calculate data

AppSet = OLAP database

Application = Cube

Aggregation into cube means improve the performances

Software – SQL Server Enterprise Edition Required

OLAP Server


Web-Folders calculate data

Local Groups

Be careful!

No solution in case of fail over (problems is the local groups)

Security for each folder and file

No addition software is required

File Server


Application server calculate data

Installation of COM components

Configuration of IIS

Windows 2003 settings (Installation Guide and Installation Best Practices)

WEB-Server


Check Diagnostic before to do installation calculate data

Attention of PTS installation

On client site it will be good to have always the last version of MDAC and PTS

Everest Client


Everest client is connected in the same time to web server and also to OLAP server

Communications Everest Client – Web server is done via HTTP or HTTPS (using ports 80 or 443)

Communications between Everest Client and OLAP server is done transparent or HTTP/HTTPS (using port 2725 or 80/443)

Once which you have in place HTTPS for web server you will have the same communications also with OLAP server

Connections and Communications


Memory allocation and also to OLAP server

Locks into database

Jobs to do backup of database (recommendation to archive the mdf and log file not to do normal backup)

Check the index for dim tables and index for fact tables

Send data is slow (is missing index for one of fact tables)

Retrieve data is slow OLAP processors is 100% all the time or to many rows into WB table (more than 50 000 records)

SQL Server-Checklist


Maximum member for Level and also to OLAP server

Memory conservation threshold

For each dimension you have to check the member count to be smaller than Maximum member and number of each level should be bigger than precedent level

OLAP – Checklist


Be careful about users rights! and also to OLAP server

Everyone should have access to Everest folder

File Server


Settings for Time out and also to OLAP server

Settings for Applications Pools for windows 2003

Check the metabase.xml for windows 2003

ASP BufferingLimit

…Entity

Web Server


Lock of OLAP can be caused by HTTP connection and also to OLAP server

90% of database Lock are caused because of custom DTS (writing into WB table) or administrative tasks

Lock Database


Design of application has a big impact into performances and also to OLAP server

Impact at level of SQL and OLAP

DTS design impact at level of SQL

Security and dimensions design impact at level of OLAP

Application Design


Check the IIS log and also to OLAP server

Check the SQL log

Check Event Viewer of servers specially for OLAP server and Web-Server

What cause the stop?


Questions ? and also to OLAP server


ad