SQL Server on ssd seems slow 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..?
Problem solved, there were IO limits on that VM.

As for SQLIO, it was lieing on hyper-v:

https://social.technet.microsoft.com/Forums/azure/en-US/b8e1674d-f1c7-4e46-b1f1-09fb0d75d82e/strange-blazingfast-io-performance-inside-hyperv-vm?forum=winserverhyperv

https://serverfault.com/questions/287311/does-sqlio-lie-when-run-from-a-hyper-v-guest-on-a-vhd