ERP systems - Performance monitoring

workaccount

We are using Navision with a SQL database on a IBM 3.66ghz Xeon with 16GB of ram. The server is connected to our SAN via fibre.

We have up to 50 users logged into Navision at any one time. Performance is up and down. The RAM is not the cause and the CPU is not maxed out. I doubt it's the fibre link but i'm not ruling out.

I need to get to the problem of these issues. Is there software out there specifically for this purpose?

What ERP system do you use actually?

Kali

I need to get to the problem of these issues. Is there software out there specifically for this purpose?

Performance Monitor. Check mem pages/sec or average disk wait time. There are several SQL options as well, but I'm not familiar with them. Check the hardware performance first and rule that out before moving to software/SQL issues anyway.

Anti

What he said

garthv

What version of Navision are you running?
Check how much each users profile is using when logged in, we've had performance issue where a user has a profile of over 4gb...not good!

workaccount

GaRtH_V wrote:

What version of Navision are you running?
Check how much each users profile is using when logged in, we've had performance issue where a user has a profile of over 4gb...not good!

4.10 - What's a user profile on Navision?

Anti

Um... Do you have anyone in your company that knows how to use the software?

workaccount

Anti wrote:

Um... Do you have anyone in your company that knows how to use the software?

Yes we do. Thanks very much, you obviously know the software very well :rolleyes:

Our users connect to a navision server and logins are handled through AD. They don't have profiles.


GaRtH_V: Yes we can see our users and cpu time they are taking up in database information through a client. But they don't have there own space or anything....4GB????

Anti

workaccount wrote:

Yes we do. Thanks very much, you obviously know the software very well :rolleyes:

Our users connect to a navision server and logins are handled through AD. They don't have profiles.


GaRtH_V: Yes we can see our users and cpu time they are taking up in database information through a client. But they don't have there own space or anything....4GB????

I dont support navapps issues... Thats His job.

matt-dublin

surely each user would have a profile as to where their information is kept?

how big is the sql database?

it may need to be archived if its hooge

workaccount

Anti wrote:

I dont support navapps issues... Thats His job.

How do you mean...his job??

matt-dublin - I'm going to look into that in the next few days or so as I've got myself a SQL admins books. I do know that the database is very large alright so we should be able to archive some stuff.

workaccount

Anti wrote:

We both work for ms. He supports navission i support something else

Oh! ok.