DFS Staging Size

(Get-ChildItem 'F:\SQL_DFS' -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

 

The above command is originally from Microsoft 

It checked the DFS folder "F:\SQL_DFS" for the largest 32 files and gives the result in GB. 

Once you have that number change the staging on the folder to that size (listed in MB). 

 

DFS will stop and work on staging if it gets to 90% of that number.  Therefore 

Multiply it by 1.12 to get the size needed to keep that from happening. 

 

 

 

 

 

 

 

$DFSSource='E:\Shared' 

(Get-ChildItem $DFSSource -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

 

 

$DFSSource2='E:\Data1' 

 

(Get-ChildItem $DFSSource2 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

 

 

$DFSSource3='E:\Procedures' 

$DFSSource4='E:\Sales Information' 

$DFSSource5='E:\SCC Reband' 

$DFSSource6='E:\Shared' 

$DFSSource7='E:\SQL Backup' 

$DFSSource8='E:\Tech Information' 

$DFSSource9='E:\Williams Documents-Accounting' 

$DFSSource0='E:\Williams Mail List' 

 

(Get-ChildItem $DFSSource3 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource4 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource5 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource6 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource7 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource8 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource9 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb 

(Get-ChildItem $DFSSource0 -recurse –force | Sort-Object length -descending | select-object -first 32 | measure-object -property length -sum).sum /1gb