Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th July 2003, 14: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

Hi,

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 ?

Thanks
Reply With Quote
Sponsored Links
Reply


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 12:49
BaaN C4, Windows 2000 Advanced Server and SQL 7.0 Server rdheeraj Operating Systems & Databases 1 30th May 2003 20:32
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 14:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 14:22
How to connect Decision Manager Server AlexGuo Open World, Portal & Decision Manager 0 17th September 2002 10:26


All times are GMT +2. The time now is 07:41.


©2001-2017 - Baanboard.com - Baanforums.com