Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fragmentation
Message
De
25/08/2009 15:06:53
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01420497
Message ID:
01420540
Vues:
49
Thank you Sergey. The maintenance plan was indeed shrinking the DBs. I will stop that immediately. Thank you again.

>See if http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx is relevant to you problem
>
>>I manage several production SQL servers, one with many SharePoint databases on it (about 200), and more are being migrated to this same server. Because of a continuing problem with fragmentation, I have a maintenance job that runs nightly that rebuilds the indexes on the user databases on the server. Even this has been unsuccessful and the level and number of fragmented indexes continues to climb.
>>
>>I have tried to implement the MS recommended method of SharePoint database de-fragmentation, but this had also not worked.
>>
>>REF: http://support.microsoft.com/kb/943345
>>
>>If anyone has knowledge or can help with this, it would be greatly appreciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform