"But you know, I love this shit"

[gothgeekgirl]

That was me to my husband after explaining to him that I'd just spent the last 4? 5? 6? Hours up to my eyeballs in technical books & websites and dtrace output because one of our DBAs was about to put his head through a wall in frustration over the miserable performance of one of his shiny, new servers. And it's true- researching and solving low

Comments

[ltempt]

Aah, but the case! What was the fault, what was the root cause?

[gothgeekgirl]

The most likely cause? The DBAs being pressured to switch a non-production box from the expensive SAS disk in the SAN to the cheaper SATA disks.

[gothgeekgirl]

So Tuesday afternoon I moved the ZIL out of the main pool on the SAN to one of the internal disks and doubled the size of the ARC cache. And lo! the system went Zoom! and the DBA is elated. I are teh awsum ;)

[ltempt]

For extra points, dump it on SSD and watch it really fly! ZIL slog is pretty good stuff.

[gothgeekgirl]

True that. I think my DBAs are in love with ZIL now.