Former colleague of mine called me up on a Saturday morning. His manager, who spends most of his day staring at a unnamed, 3rd party, leading SQL monitoring software, was really giving him hell about a table in one of their performance databases that was at 90% fragmentation.
Rebuilding the indexes didn't seem to help. So I asked him how large the table was, and it was nine pages.
I feel sorry for my buddy, who now has to try and explain this to his boss. His report of high-fragmentation tables is just not going to be cleared unless he can filter out the tiny tables.
"Against stupidity the gods themselves contend in vain." -Friedrich von Schiller
No comments:
Post a Comment