Little Things Doth Crabby Make – Part VII. Oracle Database 11g Index Fragmentation?

I just checked my list of “miscellaneous” posts and see that it has been quite a while since I blogged a rant. I think it is time for another installment in the Little Things Doth Crabby Make series.  Unlike usual, however, this time it isn’t I which the little thing hath crabby made. No, it’s got to be Microsoft on the crabby end—although I contend it is no “little thing” in this case.

According to Ed Bott’s blog post on the matter, Microsoft has fingered SQL Server as the culprit behind a recent service outage on MSDN and TechNet. What’s that adage? Eating one’s own dog-food? Anyway, the supposed SQL Server problem was database fragmentation. Huh? The tonic? According to Ed:

I’m told that Microsoft engineers are now monitoring the status of this database every 30 minutes and plan to rebuild the indexes every evening to avoid a recurrence of the problem.

How fun…playing with indexes—nightly!

And, yes, the title was a come-on. Oracle Database 11g fragmentation? Puh-leeeeze.

3 Responses to “Little Things Doth Crabby Make – Part VII. Oracle Database 11g Index Fragmentation?”


  1. 1 Noons May 8, 2009 at 1:33 am

    Oh yeah!: rebuilding indexes is very much still a large part of the life of a MSSQL dba.

    Unreal. But quite true.

    Worse: many third party application providers will NOT support a site where the dbas don’t rebuild the indexes daily.

    Even though avoiding the problem in the first place is relatively simple from 2005 onward.

    It’s not just Oracle that has myths…

  2. 2 Bernd Eckenfels May 10, 2009 at 11:15 am

    Other sources speak about other (hardware ressources) reasons. I don’t think we should jump the gun so fast.

    Bernd


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




DISCLAIMER

I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,944 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: