Go Back > Forum > Baan Quick Support: Functional & Technical > Open World, Portal & Decision Manager

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 60

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 10th July 2003, 13:11
BisBoy BisBoy is offline
Junior Member
Join Date: Jul 2003
Location: UK
Posts: 3
BisBoy is on a distinguished road
Baan: 5 - DB: Oracle - OS: AIX, NT 4
Thumbs down Decision Manager & SQL Server 7.0


Can anybody help ?

We currently have Decision Manager 2.2 installed on an NT Server (NT 4 with SP 6a).

We also have SQL server 7.0 and OLAP 7.0, both with SP2 installed.

We have 4 GB of physical memory installed and 4 x Pentium 3 700MHz CPU's.

We have all the templates installed (customised) and the size of our warehouse is about 30GB (if we do full extracts from Baan ERP, the total size of the extract files about 6GB and growing).

We've been running with iBaan Decision Manager for the last 18 months.

We are using the DM2.2 utility to 'Process Cubes' and we are finding that OLAP regularly crashes (ie the Service MS Sql Server OLAP Service crashes).

The majority of crashes occur when the memory for SQL Server is just short of 2GB and we are processing the Cubes... although it does sometimes crash when users connect and start accessing OLAP (ie. no processing on the server)... and sometimes there is lots of memory available and it crashes... also, it sometimes crashes when running ETL Runner (ie. when loading the warehouse)

We believe that if we upgrade to SQL Server 2000 and Analysis Services, that these problems may be resolved as Analysis Services and SQL server can be configured to use more memory and they are more stable than SQL 7

Does anybody else have a set-up similar to this (ie. hardware, SQL 7, data volumes being processed, etc..) ?

Is anybody else experiencing problems with OLAP crashing ?

Has anybody upgraded from SQL Server 7 to SQL 2000 to get round these kind of problems ?

Does anybody have SQL Server 2000 and a large warehouse ? If so, are you finding that you've got performance problems in extracting, loading and processing the data ?

Any help on this would be greatly appreciated ?

Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
BaaN C4, Windows 2000 Advanced Server and SQL 7.0 Server rdheeraj Operating Systems & Databases 1 30th May 2003 19:32
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 13:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 13:22
How to connect Decision Manager Server AlexGuo Open World, Portal & Decision Manager 0 17th September 2002 09:26

All times are GMT +2. The time now is 16:50.

©2001-2018 - -