We have a client who has been having performance issues. One of the developers is saying that a
select * from a table is taking ~50 seconds to perform the query (no joins just straight select with no fields). The table has 166 columns (I know that is probably over the top, but this is from an ERP software that the developer integrates with) and around 400,000 rows.
Now considering the crazy number of columns and 400k records, 50 seconds seems about right for me.
The SQL Server is running on a Hyper-V VM and has decent hard drive read/write speeds, the hard-drive specs are: 16 x 600gb 15RPM 6.0Gbps SAS drives in Raid 10.
The VM performs well and has plenty of RAM, just interested to see if any experts can chime in whether they think that query is performing within reason?