Sage 100

Sage 100 Premium Per Sage recommends tempdb database should be at least 1/3 the size of largest database How do you increase the tempdb size?

Moira, temdb will grow automatically as needed. However, the resize process takes resources away from the system when it is at it's busiest, thus the reason to try and size it correctly up front. Not easy when getting started. Here is a decent article that will give you more info and a script to adjust the size on server restart: https://www.databasejournal.com/tips/how-to-resize-tempdb.html

Thanks @ShawnSlavin also found this article https://logicalread.com/sql-server-tempdb-best-practices-initial-sizing-w01/

I like the detail from your article. It provides a more holistic explanation. We have had some really large sites where we provisioned multiple drive into individual mirrored sets so we could give data files, log files, and tempdb dedicated resources. Because each file type is written to and accessed differently (sequential vs random), larger sites with larger user bases will see a performance boost. Of course, using SSD's reduces the impact as disk read heads stop becoming a constraint but right sizing and provisioning temdb is always a good idea.