Freigeben über

Number of users might affect performance

  • Artikel

The information in this article applies to:

  • Visual Studio Team Foundation Server 2010

  • Windows Server 2003 and Windows Server 2008 

  • SQL Server 2008

  • Data-tier server

  • Team Foundation Server Complete Health Check

  • Team Foundation Server Framework Health Check

The Best Practices Analyzer tool for Team Foundation Server queries the tbl_security_identity_cache table in the Tfs_Configuration database to determine the number of users who have been added to Team Foundation.

An error appears if the number of users in that table exceeds 80,000. This error might be caused by the addition of one or more Active Directory groups that contain large numbers of users. When a large number of users are added to Team Foundation, system performance can drop.

Team Foundation Server synchronizes user and group information with Active Directory periodically (hourly by default). If you grant a large number of users access to the Team Foundation system, performance can slow during synchronization. Team Foundation Server reads information about users and group membership to propagate changes from Active Directory to the Team Foundation system. Processing very large numbers of users not only increases the synchronization load on the domain controllers, but it also puts an additional and regular load on the Team Foundation system.

To resolve this issue, determine whether a large Active Directory group has been added to the Team Foundation system (for example, a group that is labeled Domain\Domain Users). If such a group has been added, remove this group, and implement more concise security access to Team Foundation.

For more information about how to manage users and groups, see the following page on the Microsoft Web site: Configuring User, Groups, and Permissions.

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database