Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 14th November 2005, 16: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

Hello,

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.

Carles
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 14:18
Baan Sessions Slow to Open P-Matt Performance & Tuning 20 21st November 2003 14:38
How to automate sessions series of sessions ? baanlegend Tools Development 1 22nd April 2003 17:26


All times are GMT +2. The time now is 15:35.


©2001-2018 - Baanboard.com - Baanforums.com