Number of users might affect performance

  • Article

The information in this article applies to:

  • Visual Studio 2005 Team Foundation Server

  • Visual Studio Team System 2008 Team Foundation Server

  • Data-tier server

  • Health check

The Best Practices Analyzer tool for Team Foundation Server queries the tbl_security_identity_cache table in the TfsIntegration database to determine the number of users 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 help topics:

  • For Visual Studio 2005 Team Foundation Server, see "Managing Users and Groups" on the Microsoft Web site.

  • For Visual Studio Team System 2008 Team Foundation Server, see "Managing Users and Groups" on the Microsoft Web site. 

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database