Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fragmentation
Message
From
25/08/2009 15:06:53
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01420497
Message ID:
01420540
Views:
47
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform