HI all
we have baan 4c4 installed on windows 2000 with mssql2000 as backend. the problem is system gets too slow between 6 PM to 10 PM. i have checkd for all possible reasons in the system but couldn;'t fnd any. we don't even take the backup at that time. there are no extra services running at that time. and work load is also as much as it is in the afternoon. can anyone suggest me what should i do???
here is the server configuration..
IBM @Server x Series 250
Microprocessor : Intel Pentium III Xeon 700 Mhz.
Processors : 2
Processor slots : 4
RAM : 1024 MB
Hard Disk Capacity : 36 GB x 3 nos.
Operating System : Windows 2000
RDBMS : Microsoft SQL 7.0/Upgrade to SQL 2000

Thanks in advance
Nishant

Hello Nishant,

Do you have any monitoring tools that will allow you to see what's going on in the system.

When you say the system is slow is that when accessed from a client over the network? Could there be extra network traffic between this time, backups on other systems?

What batch jobs do you have running? Things like the planning engines can have a big impact on system performance.

Do you have any database/print queries being scheduled to run over night. A poorly written query could also cause these sorts of issues.

If the time is always between 6PM and 10PM then that tells me there is something running on a schedule somewhere.

These are the areas I would look at, you've probably already done this.

Regards

PJ

Hi johns
thanx for replying..
i have tried every thing u said. at that time network works fine but the system is as good as dead. i have rescheduled sytem and database backup and no batch job runs at that time. even system monitoring is not helpfull. not getting even a single clue about the origin of problem..
regards
nishant

When did this issue start?

I've noticed that you've done an upgrade from SQL7 to 2000 did it conicide with this upgrade.

I don't know SQL2000 but are there any internal 'housekeeping' processes that it runs that may cause this issue?

Regards

What are you doing after 10pm? restart of the system? In that case maybe it is indeed the housekleeping of the OS that is not optimal. Maybe the saying "A reboot a day takes your problems away" should be rephrased to "Twice a reboot a day takes your problems away" ;). I understand that this is not workable but maybe you can try it for a few days at least to see if this is the problem.

Good luck,
Dick

shuklan: ... but the system is as good as dead.W2K you are using...

Walk over to the server, start the Task Manager, check your "Processes tab", click "Processes" to see what process the system is executing. Than at least you have a clue... if the process is unknown... try to google it, if it is known, try to determine why it is running now and what it is doing.

See if you can see disk activity, network activity etc...

No virus involved?

Hello Nishant,

1) Do you have a screensaver on your server?
Long time ago I have see that some complex screensaver can give a very high processor load.

2) if it occurs after 6PM is is not possible that some people connected use an output to console to close baan and that some process are then phantom process using a lot of resource --> check your DB
I have see this on some unix system with DB2, I'm not aware if this can be present on microsoft windows+ SQL 2000 but ...

Regards

James VanderMey wrote an excellent document on systematic performance problem diagnostics for this year's BWU Fall Workshop.

The paper should now be posted on the BWU website.

Hi Nishant,

Are you autogrowing your datafiles at that time?

How about virus scans?

Dave

Hi Friends
Thanks for your replies. i'm checking all of these options. i will get back to this forum after monitoring it for sometime. Dave i have closed all the activities which were taking place at this particular time. no anti-virus checking no autogrowing, absolutely nothing. i'm still exploring the system. so hope to find the loophole in next couple of days.
thanks and regards
Nishant

Hi friends
can anyone tell me what is the role of file "$BSE\lib\db_resource". I was told to update that by baan support.
Nishant

Nishant,

The db_resource can be used to set parameters for the database driver. So, if support found that the defaults of the driver are not usefull for you, you can change them in this file. The meaning of each of the variables is database specific and can be found in the driver tech manuals.

I pubished a document in the Performance and Tuning section and described there for Oracle and DB2. SOme of them are generic so take a look at it to find help on the generic ones.

Hope this helps,
Dick