Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

It is a best practice to have tempdb divided into multiple equally sized files, each of which has been pre-sized to lessen the chance of autogrow occurring. If autogrow does occur and the database files are no longer balanced, it would be a good idea to resize the files such that they are the same size again when you are able to.

 Need more help? Search the IDERA Customer Support Portal.

Excerpt
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >