This Technet link states:
"When planning for the size of the Temp database for a primary site, plan for a size that is 25% to 30% of the site database .mdf file. The actual size can be significantly smaller, or larger, and depends on the performance of the site server and the volume of incoming data over both short and long periods of time."
I'm looking for community feedback on how big the partition holding Tempdb should be? The Tempdb is for a SQL instance that hosts both the PSS site database, as well as SUSDB.
Initially reading the above Technet paragraph, I was thinking 50% of the estimated maximum size of the PSS site database (.mdf file).
However, the phrasing about 'the actual size can be significantly larger' is leaving me uncertain.
It's also worth noting that the environment in question consists of a CAS (yes, >100K clients) with several PSSs, so database replication, and its potential (if any?) impacts on PSS tempdb sizings should also be considered...
Any feedback/experiences appreciated!