Today I learnt that it is a bad idea to use the default size (8MB) and growth (10%) values for tempdb in a production environment. And you may also want to consider using multiple tempdb files on different disks. The relevant articles are:
Maximizing TempDB performance by correct initial sizing and Optimizing tempdb performance
Thursday, June 23, 2011
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment