cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Tool performance is very slow

Highlighted
Frequent Contributor

Tool performance is very slow

Hi All,

Does anybody has idea about calculating Mega tool performace for each user.

We actually have 25-30 concurrent users working on specific server.

Consistantly some users among the group will be facing performance issue.

 

for ex: creation of an object will take more than a minute. Even a mouse move will take 4-5 seconds. But at the same time, some other user on the same server and same network will create the same type of object in 3-4 seconds (some times viceversa)

 

We are totally messed up with what is exactly going on int he tool. Can we measure the performance in user level. or do we have something to keep track of all these things.

 

Thanks in advance.

 

Venkatesh.

Colruyt Team
Tags (1)
3 Replies
Occasional Contributor

Re: Tool performance is very slow

Use the performance tools in MEGA administration to measure performance from each users workplace

Contributor

Re: Tool performance is very slow

Hi,

 

In the administration tool, at "Workstation" you can select "Diagnostic LAN" ...

 

kr,

Wim VdV

 

MEGA

Re: Tool performance is very slow

besides, may sure that database instance is configure for good performances (Update of statistics, Rebuilding of indexes)

The procedures varies according to the storage (Oracle, SQL server)

 

Specific tasks for HOPEX implementation

  • Deletion of transaction temporary data (Oracle, SQL Server)
    See the article 'RDBMS Repository Installation Guide HOPEX V1R2-V1R3 EN'
    KB 00003042
  • Deletion of historical data from repository (Oracle, SQL Server)
    See the article 'RDBMS Repository Installation Guide HOPEX V1R2-V1R3 EN'
    KB 00003170

General maintenance tasks for Oracle

  • Gather statistics

General maintenance tasks for SQL Server

  • Maintenance plan (rebuild index, update statistics, shrink ...)
    See the article 'RDBMS Repository Installation Guide HOPEX V1R2-V1R3 EN'

 

Jerome