The Accidental Team Foundation Server Admin

1. DEV327 The Accidental Team Foundation Server Admin Martin Woodward Senior Program Manager Microsoft

2. martinwo@microsoft.com @martinwoodward http://www.woodwardweb.com http://www.radiotfs.com Martin Woodward

3. I work here

4. On this

5. I also co-authored these http://tinyurl.com/protfs

6. Why are we here? tag – you’re it!

7. Architecture Client Tier Application Tier (AT) Data Tier (DT) Collection Databases OLAP Cube Database Configuration Database Relational Warehouse

8. Protocol Architecture Client Tier

9. Team and Project Overload Team Foundation Server (TFS) Team Project Collection (TPC) Team Project Collection Team Project Collection Team Project Team Project Team Project (TP) Team Project Team Project Branch Team Project Solution Team Project Project Project Team Project Project Team Project Solution

10. TFS 2010 Topology Single Server TFS HR Applications TFS AT

11. TFS 2010 Topology Dedicated Admin Tools App Tier Data Tier TFS AT HR Applications Clustered SQL Server

12. TFS 2010 Topology Network Load Balancing HR Applications Team Project Collection TFS AT NLB Team Project Collection Finance Applications VIP TFS AT Company Web site TFS AT Another SQL Server

13. TFS 2010 Topology TFS Build Farm HR Applications TFS AT NLB Finance Applications TFS AT TFS Proxies Company Web site TFS AT Test Rig SharePoint Farm Data Warehouse Project Server Virtual Machine Manager

14. Recommended Hardware Configurations Capacity Planning: http://vs2010quickref.codeplex.com/

15. Case Study: Teamprise • 25 Total Users (7 Very Active) • 1 Single Server Instance (one core Xeon 2Ghz, 4GB) • 2x160GB 10K SCSI Drives (RAID1) • Backups to Tape • 1 Build Server • 1 Project Collection • 1 Team Project • In place upgraded since TFS 2005 Beta 2

16. Case Study: CodePlex • 2.5 million users worldwide • 15,000 Team Projects • Upgrade from TFS 2008 to TFS 2010 • TCO down 88% • Hardware down 55% • Capacity doubled

17. Team Foundation Server @ Microsoft 42 instances 19,700 unique users 6,154 team projects 7.9 million work items

18. Administration Console Command-Line Tools TFSConfig.exe TFSSecurity.exe WITAdmin.exe tf.exe TFSServiceControl.exe tfpt.exe TFS Power Tools ( tinyurl.com/tfspt) TFS Admin Tool ( tfsadmin.codeplex.com ) Team Foundation Sidekicks ( tinyurl.com/tfssidekicks) Administration Tools

19. Administration Tools demo

20. Start from clean machine if possible (64-bit) Use VM’s to practise Be careful when imaging TFS instances Only use Reporting / SharePoint if you need them Run BPA before upgrade and fix any issues Client Compatibility Matrix – tinyurl.com/tfsCompatMatrix Installing / Upgrading TFS

21. Upgrade Team Projects to enable 2010 Features Test management Agile Planning Workbooks New reports (tfptaddprojectreports) New portal (tfptaddprojectportal) Update work item types Add work item categories Post Upgrade Steps tinyurl.com/tfsUpgrade

22. Recommended Hardware Configurations Capacity Planning: http://vs2010quickref.codeplex.com/

23. Team Foundation Server SharePoint ReportingServices TFS Server Admin Project Admin Project Reader Project Contributor Managing Users Team Foundation Administrators Site Administrator Content Manager, Site Administrator Project Administrators Project site-level Administrator Project site-level Content Manager ProjectContributors Project site-level Contributors Project site-level Browser ProjectReaders Project site-level Readers Projects site-level Readers

24. Users and Permissions demo

25. Disaster Recovery Planning • Define goals • Cost of downtime • What data loss is acceptable • Backup retention, storage and security • Define responsibilities • Test and practise backup plan

26. The Crown Jewels Client Tier Application Tier (AT) Data Tier (DT) Collection Databases OLAP Cube Database Configuration Database Relational Warehouse

27. Back-up Components

28. Backing up TFS demo

29. Further Reading (Backup) • SQL Server • HA & DR Architectures – tinyurl.com/SQLDR • Full Database Backups – tinyurl.com/fullSqlBackup • Differential Backups – tinyurl.com/diffSqlBackup • Transaction Log Backups - tinyurl.com/tlogBackup • SharePoint – tinyurl.com/SharePointBackup • Lab Management – tinyurl.com/vmmBackup • TFS Backup/Restore - tinyurl.com/tfsBackup • Backup/Restore Wizard - tinyurl.com/tfspt • Pro TFS 2010 Book, Ch 19 - tinyurl.com/protfs

30. Looking for Performance Bottlenecks Client Tier

31. Monitoring System Health and Performance Bottlenecks demo

32. Calls to Action • Take backups • Check configuration using BPA • Monitor your Server Health • Listen for perf issues from users • Look for evidence in logs • Hardware and SQL Perf is No.1 Suspect • Don’t mess with TFS Database Schema

33. thank you

34. Thanks • TFS Developer Support Escalation Team • Grant Holiday, Brain Keller, Ed Blankenship • Visual Studio ALM Rangers • Visual Studio ALM MVP’s & Inner Circle Partners

35. martinwo@microsoft.com @martinwoodward http://www.woodwardweb.com http://www.radiotfs.com http://tinyurl.com/protfs Martin Woodward

36. Required Slide Speakers, please list the Breakout Sessions, Interactive Discussions, Labs, Demo Stations and Certification Exam that relate to your session. Also indicate when they can find you staffing in the TLC. Related Content • Breakout Sessions • DEV202: Team Foundation Server for Everyone • DEV306: Branching and Merging for Parallel Development • DEV310: Team Build 2010: From Build Definition to Custom Workflow Activities in 75 Minutes • DEV311: Deep Dive into Microsoft Visual Studio Team Foundation Server 2010 Reporting • OSP203: Application Lifecycle Management: Microsoft Project Server 2010 and Microsoft Team Foundation Server 2010, Better Together • Interactive Sessions • DEV271INT: Would You, Could You with TFS?

37. Required Slide Speakers, please list the Breakout Sessions, Interactive Discussions, Labs, Demo Stations and Certification Exam that relate to your session. Also indicate when they can find you staffing in the TLC. Related Content • Hands-on Labs • DEV366HOL: Branching and Merging Visualization with Microsoft Visual Studio Team Foundation Server 2010 • DEV367HOL: Planning Your Projects with Microsoft Visual Studio Team Foundation Server 2010 • Product Demo Stations • TLC-DEV: Team Foundation Server • Related Certification Exam • 70-512: Visual Studio Team Foundation Server Administration • Find Me Later At…

38. DEV Track Resources • http://www.microsoft.com/visualstudio • http://www.microsoft.com/visualstudio/en-us/lightswitch • http://www.microsoft.com/expression/ • http://blogs.msdn.com/b/somasegar/ • http://blogs.msdn.com/b/bharry/ • http://www.microsoft.com/sqlserver/en/us/default.aspx • http://www.facebook.com/visualstudio

39. Resources • Connect. Share. Discuss. http://northamerica.msteched.com Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

40. Complete an evaluation on CommNet and enter to win!

42. © 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.