We recently moved SQL Server to SSD and the performance gain is not that great.
SQLIO shows enormous gains (15-100 times faster), getting sequential read/write speed up to 6GB/s.
But when we do a simple query:
select * into table2 from table1
it gets roughly like 60MB/s. 2GB table takes 30 seconds to finish.
Is this normal? What speed is considered average for SSD for such a simple query? Don't believe it's a RAM issue, 50GB of RAM..?