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
Old 22nd March 2003, 01:37
rosalbaperez rosalbaperez is offline
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 Perez
Reply With Quote
Old 25th March 2003, 10:11
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
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,
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
Sponsored Links

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 13:56
Performance Issue... suhas-mahajan Performance & Tuning 2 18th March 2003 17:01
Performance Issue... r_nagu Performance & Tuning 4 19th February 2003 17:57
Performance issue while running DNC ! mraguthu Distribution, Transportation & Warehousing 0 1st April 2002 23:31
Performance issue while running EDI-DNC to create Sales Orders. How I resolve? mraguthu Tools Development 0 28th March 2002 20:08

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

©2001-2018 - -