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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 14th November 2005, 17:09
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
There can be lots of causes.

One thing we found is putting field level authorizations on user roles slows things down dramatically. It creates lots of sql calls as you mentioned seeing when you trace, making it look like a coding problem, index problems, etc. One easy way to check if this is your problem is to run as a superuser and see if the slow down still occurs.
Reply With Quote
  #3  
Old 15th November 2005, 12:15
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
Lisa,

Thank you for your information.

Unfortunately, all users are defined as superusers. So, this is not the problem.

Regards,

Carles
Reply With Quote
  #4  
Old 16th November 2005, 01:14
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
If you read chapter 2 of the Performance Tracing and Tuning guide you see the Call Graph Profiler. This shows the times of all your queries and other activities. This can help you to identify to find your problem.

It helped many users, so I hope it will help you as well.

Oh bye the way, if you find the problem, feel free to post it here so we can help you to look for a solution.

Good luck,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #5  
Old 16th November 2005, 01:54
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Quote:
Originally Posted by Carles
Hello,

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

In our opinion, the only conclusive test was the trace, because it seems that something is done wrong in the program.
Don't those two statements seem to contradict eachother?

I don't think that software degrades with time. =)

You need to look further into the trace, you might find your answer there, but you can't really tell if there is a problem with the session or is it just an indication that, perhaps, you need to close or archive some wherehouse orders...

Think about new Company level changes that happened in april, did you start shipping a new product line? did you take on some new business? etc.

Good luck!

Dave
Reply With Quote
  #6  
Old 16th November 2005, 02:13
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Quote:
Originally Posted by dave_23
I don't think that software degrades with time. =)
Sure it is! You need the latest hardware to support the latest software as the latest software is just the previous version with an additional layer .

Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #7  
Old 16th November 2005, 15:35
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
Dick,

The same day I posted my question, I found the Performance Tracing and Tuning guide, so now, further to the initial MSQLPROF trace I mentioned in my post, I have the profiling of the same session.

The information I have is in essential the same. This means, that I do not yet what’s the problem.

Do you have any idea who can help me to analyze all the trace information?

Thank you

Carles.
Reply With Quote
  #8  
Old 16th November 2005, 18:00
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Carles,

Please do an Call Graph Profile as it will give you much more info on only 1 HTML page. Drop it here so we all can figure out what goes bad.

Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #9  
Old 18th November 2005, 10:21
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
Dick,

Attached you can find the CGP of session tdsls4201s000 ( copy order lines )

This file was been generated after copying 10 lines and the time it took to do that was 3 minutes.

I hope someone can find out what happen.

By the way, is it normal that profile generates 85 files of session tdcms0141m000? ( Other times I use the profile always generates a lot of this session files )

Regards

Carles
Attached Files
File Type: zip profile.1128.tdsls4201s000.7.zip (236.4 KB, 75 views)
Reply With Quote
  #10  
Old 16th November 2005, 16:27
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
Quote:
Originally Posted by Carles
Since April of this year, some sessions go more and more slowly everyday..
In our opinion, the only conclusive test was the trace, because it seems that something is done wrong in the program.
Quote:
Originally Posted by dave_23
Don't those two statements seem to contradict eachother?

I don't think that software degrades with time. =)
Dave

I don't think these points are opposed.

If the problem is a bad select in the program, when you have small tables the program could work. As soon as table grows, the program will go more slowly.

But, please, don’t think I assure that the program is not well done. It was my first idea after making all tests and it is an opinion of non Baan expert.

I posted my problem to have opinions of Baan gurus, because maybe the problem could be very different from what I thought.

In any case, thank you for your reflection.

Regards

Carles
Reply With Quote
  #11  
Old 16th November 2005, 17:48
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
I was just more or less trying to point out that you had further to go.
Don't just rest on it bug in the program..

I think you're on the right track with the Performance tuning guide.

Dave
Reply With Quote
  #12  
Old 12th October 2013, 16:52
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
This topic was specific on tdsls4201s000.
But indeed many sessions could have issues and many solutions have been made. As this answer was from 2005, I recommend to start a new topic if you have sessions that are not performing well.
And of course, read solution 22881401 as it has lots of ideas on how performance can be measured, traced and improved.
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
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
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 07:44.


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