Versions Compared

Old Version 8

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 9

changes.mady.by.user eric revollo

Saved on

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.

 



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

...

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 |
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 |
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 |
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...