I have this problem now that I am trying to save the world (by reducing carbon use).
When my system goes into hibernation the hard drive connected to the SATA port stays asleep . Both hard drives are Maxtor. I have to go into control panel, device mgr, and "scan for hardware changes" to get the drive to wake up again. Hibernation is quite important as the PC takes too long to boot every time.
I am using xp sp2, 2gb ram, c2d 6750, 1x320gb ide pata (OS disk) 1x 320 SATA disk.(page file). Page file relocated as possibility to keep device awake.
And I cannot overclock my system to any degree as it becomes unstable whatever mem /cpu voltage I use. My memory is Crucial ballistix 6400...I blame the red hot north bridge as I use an Arctic cooler on the CPU.