Well let me start by saying that I don't know what a silent PowerMac G5 should sound like so I just might be oversensitive to the noise.
It wouldn't go to sleep , instead the fans ramped up full speed after a minute or 2 but I've deducted this issue being the LSI SCSI card I had installed...