Impromptu Outage

Hello all, I hope you all had a great Christmas - we certainly enjoyed the break and are looking forward to 2006, which promises to be an exciting year for DearDiary.Net so far!
We had a small outage today where I discovered some indexes (or should that be indices?) on the database that were never used and maintaining them was a lot of extra work for the database. In theory it should speed things up although I don't imagine it'll really be all that noticeable to end users, but perhaps it'll stop the disk thrashing and warming the server room up a little...
We're enjoying some rare snow coverage and looking forward to the New Year.
We had a small outage today where I discovered some indexes (or should that be indices?) on the database that were never used and maintaining them was a lot of extra work for the database. In theory it should speed things up although I don't imagine it'll really be all that noticeable to end users, but perhaps it'll stop the disk thrashing and warming the server room up a little...
We're enjoying some rare snow coverage and looking forward to the New Year.
Comments (4)
waterspriteflying (Legacy)
You know what's amazing to me? You understand all this! I just sit here reading, and nodding my head wisely, and hoping some of your knowledge and expertise will sort of rub off on me.
Thanks again for you work!
Hugs,
Ani
PS: Merry Christmas, Happy Hanukkah, a Kwality Kwansa, a Satisfying Saturnalia, and a Yowza of a New Year!
Thanks again for you work!
Hugs,
Ani
PS: Merry Christmas, Happy Hanukkah, a Kwality Kwansa, a Satisfying Saturnalia, and a Yowza of a New Year!
alifelessordinary (Legacy)
did you get my suggestion on MSN yesterday stevie poo?
causingchaos (Legacy)
It's been 6 years for real? I was just guessing around when I figured I started here a little over 5 years ago. But wow.
Have fun with your index issue. I didn't really notice any slowness.
Have fun with your index issue. I didn't really notice any slowness.
causingchaos (Legacy)
I was in my old diary here that's private now but it should go back to like 2000 but it doesn't. It goes back to 02 and I quit writing there in 03 so I don't know if that's anything to do with your adjusting that whole diary thing or not.