When we switched from VSS to Vault, at first we had turned Folder Security off because this would make the import process even slower. Now that all files are transferred to Vault, we are thinking about turning Folder Security on, it has some advantages for the way we work. However, if you read the messages here in the forums, there is talk of Folder Security affecting performance. What I would like to know is just how serious FS affects performance in the present version (3.0.7) of Vault and in the upcoming version. It is understandable that some actions take a bit more time because security has to be checked, but I can not imagine a significant increase in wait times being necessary if FS is on.
I have done some tests with FS turned on during the weekend, when no other users where busy. I did some repeated check ins and check outs of the same set of files, with FS on and off. The wait times varied enormously, there are obviously other things affecting performance. But I did see a higher average wait time with FS turned on. What I would like to know is if Sourcegear can give some information on the performance implications of turning FS on in present and future versions of Vault. Are all actions affected or some more than others?
Regards,
Frans
Folder Security and performance
Moderator: SourceGear
Frans:
When folder security is turned on, the entire repository tree needs to be checked during operations like refresh of a checkout list, history queries on folders, etc. Since each user could have a different "view" of the repository, this is generated dynamically at each request.
Since you've done a VSS import, you may want to rebuild or defrag the indices. Also if you defrag the indices, you'll want to update the database statistics. Additionally, you may want to check the fragmentation level your OS file system where the database is located. These items *may* help with some of the performance problems.
Also, I'd like to suggest trying the Vault 3.1 Beta 2 server. We've made some optimizations there. You will really see a benefit when the user has *not* been denied part of the tree (only set to a lower permission level).
One final suggestion. If the pieces of your tree are independent of each other (not part of the same solution or build), you may want to consider breaking up the repository into smaller "mini" repositories. If the folder count is smaller, then checking repositories with a smaller folder count will give you an increase in performance.
HTH
When folder security is turned on, the entire repository tree needs to be checked during operations like refresh of a checkout list, history queries on folders, etc. Since each user could have a different "view" of the repository, this is generated dynamically at each request.
Since you've done a VSS import, you may want to rebuild or defrag the indices. Also if you defrag the indices, you'll want to update the database statistics. Additionally, you may want to check the fragmentation level your OS file system where the database is located. These items *may* help with some of the performance problems.
Also, I'd like to suggest trying the Vault 3.1 Beta 2 server. We've made some optimizations there. You will really see a benefit when the user has *not* been denied part of the tree (only set to a lower permission level).
One final suggestion. If the pieces of your tree are independent of each other (not part of the same solution or build), you may want to consider breaking up the repository into smaller "mini" repositories. If the folder count is smaller, then checking repositories with a smaller folder count will give you an increase in performance.
HTH
Jeff Clausius
SourceGear
SourceGear
-
Guest
Thank you Jeff. We already rebuild the indexes once a week as part of an automated maintenance procedure. Also, we have defragmented the disk once after the import and we will do so again once the fragmentation level gets too high.
What I really was looking for was a statement like 'turning on Folder Security will increase wait times by X% for check ins and by Y% for check outs'.. or something similar. I could not get a good idea of that myself. A lot of other factors seemed to influence performance when I was testing, it was not easy to isolate the effect of Folder Security.
If the performance loss is acceptable, we will turn FS on. If not, we will have to think change out way of working a bit.
Regards,
Frans
What I really was looking for was a statement like 'turning on Folder Security will increase wait times by X% for check ins and by Y% for check outs'.. or something similar. I could not get a good idea of that myself. A lot of other factors seemed to influence performance when I was testing, it was not easy to isolate the effect of Folder Security.
If the performance loss is acceptable, we will turn FS on. If not, we will have to think change out way of working a bit.
Regards,
Frans
Yes, we use DBCC commands. Actually, we use the script for rebuilding indexes and updating statistics you yourself provided in this topic.
We plan to deny a few users read access to most of the tree. The majority will have read access to the whole tree and write access to the projects she or he is working on. So you are saying that in this case, the majority of users will benefit from the 3.1 optimizations if Folder Security is turned on?
We will certainly upgrade as soon as version 3.1 becomes available. I heard you can win a free dinner with Angelina Jolie if you do..
We plan to deny a few users read access to most of the tree. The majority will have read access to the whole tree and write access to the projects she or he is working on. So you are saying that in this case, the majority of users will benefit from the 3.1 optimizations if Folder Security is turned on?
We will certainly upgrade as soon as version 3.1 becomes available. I heard you can win a free dinner with Angelina Jolie if you do..
Yes. We've also made some other optimizations that will help in either case. But the bigger win will be in the scenario where the user has limited access.frans wrote:So you are saying that in this case, the majority of users will benefit from the 3.1 optimizations if Folder Security is turned on?
I believe with all of the controversy around Brad Pitt, this contest has ended.frans wrote:I heard you can win a free dinner with Angelina Jolie if you do..
Jeff Clausius
SourceGear
SourceGear