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 22nd March 2003, 00:37
rosalbaperez rosalbaperez is offline
Member
 
Join Date: Oct 2001
Location: San Diego
Posts: 32
rosalbaperez is on a distinguished road
Baan: IVc4, SP4 - DB: MS SQL 2000 - OS: WIN 2K
Intermittent performance issue tfacp2120s000

We have experienced really bad performance issues in subsession "Assign Credit Notes to Invoices". It takes about 5 minutes or more to show the first record, it opens the session but not data is shown.

First time I tried to investigate the problem it ran just fine (of course the user thinks I did something ). I did run the session with TT_SQL_TRACE and I saved the file "just in case". Two days after, I ran the session again and I experienced a 10 min delay! , so I saved the TT_SQL_TRACE again.

These are some of the facts I have encounter:

1. In the server, the "sqlservr.exe" process is using 1.7 GB of Memory and is specific to this transaction.
2. The first log file is 464 KB, the second is 30.6 MB ! for the same transaction.
3. There is no queries where the fetch time for 1st row is greater than 1 sec.
4. The CPU utilization is minimum (10-15%)
5. I run same session in test company and it runs fine.

Has anyone experince problems with this session? Or any ideas on how to fix this issue?

Thanks in advance!

Rosalba
__________________
Rosalba Perez
Reply With Quote
  #2  
Old 25th March 2003, 09:11
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
Interesting prob

As you use SQL Server you use Level 1.

As the data can be different between time A and B I assume it is possible that a bad query behaves different between time A and B, but it sounds weird to me that TT_SQL_TRACE differs between time A and B for the same session. Is it possible to upload the first 100 lines or so of each trace?

Kind regards,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
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
Performance issue kv0512 Tools Development 1 30th October 2003 12:56
Performance Issue... suhas-mahajan Performance & Tuning 2 18th March 2003 16:01
Performance Issue... r_nagu Performance & Tuning 4 19th February 2003 16:57
Performance issue while running DNC ! mraguthu Distribution, Transportation & Warehousing 0 1st April 2002 22:31
Performance issue while running EDI-DNC to create Sales Orders. How I resolve? mraguthu Tools Development 0 28th March 2002 19:08


All times are GMT +2. The time now is 08:28.


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