Explanation:

• If your Files table is large:

EXEC prc_DeleteUnusedFiles 1, 0, 100

@partitionId = 1, @chunkSize=100

The nature of prc_deleteunusedfiles is that once it deletes a bunch of files, that causes more files to be able to be deleted due to our delta chains. This procedure is run on a weekly schedule so it will clean up the next set of files the next time the job runs.  This procudure can executed  repeatedly until FWFilesToDelete stops decreasing.This procedure may run for a long time, that’s why it has the third parameter which defines the batch size.

• If your Content table is large:

EXEC prc_DeleteUnusedContent 1

@partitionId = 1

• Queries to monitor the DB size

SELECT COUNT(*) FROM tbl_File f WHERE f.PartitionId = 1 AND f.OwnerId = 1 AND f.DeletedOn IS NULL AND f.CreationDate < DATEADD(DAY, -1, GETUTCDATE()) 

AND f.FileId NOT IN (SELECT FileId FROM tbl_Version WHERE PartitionId = 1 AND FileId IS NOT NULL)

SELECT COUNT(*) from tbl_File f WHERE f.DeletedOn IS NOT NULL

Solution:

1. Open Visual Studio IDE  
2. Go to Tools --> Options in Visual Studio menu and open the options. Select Source Control --> Visual Studio Team Foundation Server and tick the option "Show deleted items in Source Control Explorer" and click OK.
3. Now you can see the deleted files appear in Source Control Explorer. Right click on the Folder/File you want to restore and click "Undelete" to get it restored.

Explanation:

The default display limit for the task board is 500 tasks.For performance reasons, the task board is restricted to display a maximum of 500 work items. When you open the task board, all work items are loaded into cache. so changing the limit increases the memory demand on your clients and might cause issues. Limiting the number of work items may yield quicker load times

Work Around:

You can modify the process template to increase the limit.

For TFS 2012, edit Agileprocessconfig.xml

For TFS 2013, edit ProcessConfiguration.xml

Step 1: Export Agileprocessconfig.xml from the team project

witadmin exportagileprocessconfig /collection:"http://tfs:8080/tfs/DefaultCollection"

 /p:DefaultProject /f:"c:\Agileprocessconfig.xml"

Step 2: Add a attribute "workItemCountLimit" to the <IterationBacklog> element as below

<?xml version="1.0" encoding="utf-8"?>
<AgileProjectConfiguration>
  <IterationBacklog workItemCountLimit="1000">
    <Columns>
      <Column width="50" refname="Microsoft.VSTS.Scheduling.Effort" />
      <Column width="400" refname="System.Title" />
      <Column width="100" refname="System.State" />
      <Column width="100" refname="System.AssignedTo" />
      <Column width="50" refname="Microsoft.VSTS.Scheduling.RemainingWork" />
    </Columns>
  </IterationBacklog>
  <ProductBacklog>
    <AddPanel>
      <Fields>
        <Field refname="System.Title" />
      </Fields>
    </AddPanel>
    <Columns>
      <Column width="400" refname="System.Title" />
      <Column width="100" refname="System.State" />
      <Column width="50" refname="Microsoft.VSTS.Scheduling.Effort" />
      <Column width="200" refname="System.IterationPath" />
      <Column width="200" refname="System.Tags" />
    </Columns>
  </ProductBacklog>
</AgileProjectConfiguration>

Step 3 : validate your Agileprocessconfig.xml

witadmin importagileprocessconfig /collection:"http://tfs:8080/tfs/DefaultCollection"

 /p:DefaultProject /f:"c:\Agileprocessconfig.xml" /v

 Step 4: Import Agileprocessconfig.xml to the team project

witadmin importagileprocessconfig /collection:"http://tfs:8080/tfs/DefaultCollection"

 /p:DefaultProject /f:"c:\Agileprocessconfig.xml"

Explanation:

After updating TFS 2013 server with update TFS 2013.2, Shared Parameters feature need to be activated manually for each team project. This feature provides to testers and test leads the ability to manage test parameter data at one place by using Shared Parameters. Any subsequent changes to parameter data can be updated at one place and all the test cases referencing the Shared Parameter are automatically updated

Solution:

• Open team project web access.
• Click on "Test" tab --> "parameters" option

• Click on "Configure feature" option.

• Click on "Verify" & "Apply" button

Explanation:

• Visual Studio Scrum 2013.2 Process Template has support for Shared Parameters which will enable testers the ability to manage test parameter data centrally. New Shared Parameter work item type, category, and link type are updated to the process template.
• The ProductBacklog.wiq and SprintBacklog.wiq queries have been removed