Go Back > Forum > Baan SIGs > Performance & Tuning

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: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 14th November 2005, 17:52
Carles Carles is offline
Junior Member
Join Date: Feb 2004
Location: Catalunya
Posts: 11
Carles is on a distinguished road
Baan: 5c - DB: SQL server - OS: Windows
Slow sessions


Since April of this year, some sessions go more and more slowly everyday.

Due to this problem, we had carried several tests, in both hardware and software, without success:

1.First thing we did, was to the check integrity of DB. No problem was found.
2.Then, we re-installed Baan and DB in different computers. So now, we are running Baan ERP 5.0C service pack 10 in one machine with Windows 2003 OS and MS-SQL 2000 – LEVEL 2 in other machine with Windows 2000 OS.
3.We audit our internal network and no problem was found.
4.We traced some sessions that go slowly. For example, we traced tdsls4201s000 (copy sales orders lines) when we copied only 10 lines and we found a lot of SQL sentences (102968 selects of table whinr110 or 91279 selects of table tdsls401, between others).

In our opinion, the only conclusive test was the trace, because it seems that something is done wrong in the program.

Besides if we erase all entries in table whinr110, the time to copy 10 lines in the mentioned session drops from 2 minutes 30 seconds to 15 seconds only.

Is there anyone who had similar problems before? Is so, what was the solution?

Please, do not suggest to run the delete sales order history session because it is not working well with service pack 10 and due to the personalizations it is difficult to update to service pack 15.

Thank you.

Reply With Quote

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
Slow System rmarles Operating Systems & Databases 13 19th October 2005 15:18
Baan Sessions Slow to Open P-Matt Performance & Tuning 20 21st November 2003 15:38
How to automate sessions series of sessions ? baanlegend Tools Development 1 22nd April 2003 18:26

All times are GMT +2. The time now is 01:49.

©2001-2018 - -