GilaMonster (2/10/2013)
Rum a load test of your app, see how large TempDB gets. Set default size to slightly larger.
Same thing I do. Other option is to run it for a while and monitor. Then adjust your settings.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events