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

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 07:49.

©2001-2018 - -