Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

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 12th April 2007, 16:55
malfaro malfaro is offline
Junior Member
 
Join Date: Apr 2007
Posts: 4
malfaro is on a distinguished road
Baan: Baan IV 4 c4 - DB: SQL server 2000 - OS: Windows 2000
MS-SQL Server Tunning For Baan IV
Baan: Baan IVc4
DB: SQL Server 2000
OS: Windows 2000
C/S: Both

Hello, how are you?

We have Baan IV c4 with MS-SQL server 2000 in a W2000 server. (with level 2)

The ODBC connection is very fast and the baan access is very slow in comparison with.

We are preparing a document to tuning the DB for Baan. And the first thing in the list is a task to rebuilding the index in SQL 2000 every X time. The second check the perfomance indicator to look for the bottlenecks.

The Question is : Can someone send me any information about tunning / perfomance SQL server for Baan than we must consider ??

Thanks

Malfaro
Reply With Quote
Sponsored Links
  #2  
Old 18th April 2007, 16:24
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 573
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hi Malfaro,

do you know this thread http://www.baanboard.com/baanboard/s...ad.php?t=24898 ?

Regards,
Juergen
Reply With Quote
  #3  
Old 23rd April 2007, 16:42
malfaro malfaro is offline
Junior Member
 
Join Date: Apr 2007
Posts: 4
malfaro is on a distinguished road
Baan: Baan IV 4 c4 - DB: SQL server 2000 - OS: Windows 2000
thanks, but....

Thanks, this guide is very usefull and there are a lot of things to check in my configuration.
But my question is about the maintenance of the SQL server with baan and the tunning of that database.
We are running with our configuration for years and our database grow and we want to maximize access speed. For example we are programming a task to reorganize the tables index because if you don't extract the information and you import after, the index never have been reorganize. If you create and delete information in a table (level 2) when the time goes the index is useless.

Thanks for your futures answers

Miguel Angel Alfaro
Reply With Quote
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
Is SQL Server any good? Paul P Operating Systems & Databases 8 20th October 2005 19:08
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 14:11
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


All times are GMT +2. The time now is 06:54.


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