SQL Server 2016 TempDB physical file size is different than SQL System Catalog And Proportional Fill Algorithm is not working as expected
Also another major issue is proportional fill algorithm is not working as expected as couple of files are having more size when compared to other files. What can be the reason for it?


One reason for this could be that the files were intentionally (mis)configured like this.

Try querying sys.master_files as well, which will have the last configured size value for the tempdb files:

SELECT 
    [name], 
    [file_id], 
    [type_desc], 
    [size] * 8 / 1024 [size_mb]
FROM sys.master_files
WHERE database_id = 2


You could manually shrink the main tempdb file to 350 MB to get the sizes allocations spreading around normally again.



Regarding your other question, I'm really not sure why the value in sys.database_files is different from what is shown in the file explorer.  Hopefully someone else can come along and solve that mystery.