I have a database and a table in this database has 1000000 rows. I have this database to my pc and my server and when I select * from this table the result is 10 seconds to my pc and 26 seconds to my server.
The configurations of the PC and Server are the following:
PC ---> i5-3,3Ghz 4 cores (4 Logical CPUs), simple SSD disk, 16 Gb Ram.
Server ---> 2xXeon 2,2Ghz 2x6 Cores + hyperthreating (24 Logical CPUs), Direct Attached Storage with 4xSSD Raid5, 128Gb Ram
When I backup database to disk NUL I get 500mb/sec to my PC and 1900mb/sec to my server.
Is this normal? I believe that my server should be faster if not the same. The only thing tha is slower to my server is the Ghz of CPU but my server has 2 CPUs with so many Cores.
Any suggestions ?