Discussion Forum for StarTeam Users


Re: Performance trouble


[ Follow Ups ] [ Post Followup ] [ Discussion Forum for StarTeam Users]

Posted by Martin Stead on December 16, 2000 at 14:09:00:

In Reply to: Performance trouble posted by Kjell-Olov H?dahl on October 23, 2000 at 11:06:57:

: We have been running StarTeam (currently version 4.2) in a number of projects using an Access database.

: About ten users log in everyday and there are about ten projects with a history of about two years in the database.

: Lately, StarTeam has started to perform sluggishly. What may be the problem?
: Should we convert the database to SQL Server? Are we using the wrong form of diff-storage scheme (use of forward or backward diff storage)? What else may we suspect?

: Please answer with a list of known performance-boost actions we may consider and investigate.

: Sincerely
: /Kjell-Olov H?dahl (?-Systemdesign AB, Sweden)

Hi,

Fragmentation of the database, cache and vault and logs itself can be a major issue on top of the other points raised, best pratice would be separate these on a seperate disk "slices" under nt and perform defragmentation during off hours of work.
Also not writing anything else to these volumes if key to success as well.

I would suggest a volume for vault+ cache, one for the db itself and another for attachments and yet another for logs for the optimum setup.


Follow Ups:



Post a Followup

Name:
E-Mail:

Subject:

Comments:


[ Follow Ups ] [ Post Followup ] [ Discussion Forum for StarTeam Users]