as I am no technician.
Since this is a Dell Dimension it is a Desktop, meaning it has a separate monitor.
Instead of sleep mode, why not just turn off the monitor and hard disk? On my Win 7 Desktop I have the power settings to turn off the display after 2 hours but "Never" put computer to sleep. In Advanced Power Settings my hard disk gets turned off after 90 minutes. In truth I am never away from the computer for anything like that long when it is running and if I am away, I power down completely, but I see why your setup needs to be different.
Again guessing, I suspect that the monitor draws the most power and the desktop minimal, especially if the hard disk is powered down after any period of non-use. I assume then that the OS would just 'twiddle it's thumbs' in the background until it is required.
Mark
I have a Dell Dimension E521 PC running Vista Home Premium. I am in the process of making it a NAS for other laptops in the house. I would like to turn on the sleep mode to conserve power. But how do I wake it up for NAS application?
I have been using my PC as a Logitec Media Server for my streaming players. When I turn on a player, it will wake up the PC. So I know my PC can enter sleep mode correctly.
However, with the filing sharing, I cannot figure out how to wake up the PC. Any help will be greatly appreciated.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic