Configuring TempDB for Optimal TFS Performance
Ottimizzare TFS significa soprattutto ottimizzare le
tecnologie su cui si basa (AD, Sql, WSS, etc...).
In questo post si parla dell'ottimizzazione del TempDB
So here are some pointers found during our testing:
1. Manually grow TempDB -... SQL Server reverts back to the original TempDB size upon re-start - thereby you incur the cost again after every restart...
2. Use multiple equal sized data files - if you are using a multi-processor data tier, use N equal sized data files (when N is the # of processors, the sum of all the data files can equal 20% of all your databases)...
Fonte: Configuring TempDB for Optimal TFS Performance