DB With DB
SQL: The Language to Live Life
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.
Newer Posts
Older Posts
Home
Subscribe to:
Posts ( Atom )