Versions Compared

Old Version 6

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Fabiola Arias Navia

Saved on

Key

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

...

IDERA SQL Inventory Manager has detected that the file sizes for tempdb are not equal for one or more SQL Server instances. While this is not a critical error, the size difference can lead to performance problems for tempdb, which is a shared system resource and therefore impacts the entire SQL Server instance.

...

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.

...



Scroll Ignore
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

...