Monday, November 28, 2016

Tempdb Sizing

Many DBA’s Prefer to set 100-200 GB size for  database tempdb,  out of this space 90 % for data file(.mdf) and 10% for Log file(.ldf), this sizing help to prevent uncontrolled size growth & reduce contention.