Do I need to store the entire database on solid state disk?

No. Texas Memory Systems advises customers to only move their most frequently accessed files, tables, etc to solid state disk. For some customers, this means putting the entire database in solid state disk.