To answer your question : yes you should run windows from an SSD to gain max. performance.
For the HDD i'd say try a different SATA connection. If that doesn't make a difference you can check your BIOS to see if it detects the HDD at all. If not then the HDD might be dead.
Also do not forget to...