Why is the query execution speed on a weak server higher than on a more powerful one?

Question

SQL

Good afternoon.
There are two servers.
Weak:
Dell T30
Xeon E3-1225 v5 @ 3.30GHz, RAM 32GB
Windows Server 2016 Standard 64-bit
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
SSD 240GB - system + tempdb
HDD01 4TB - data
HDD02 4TB - log
More powerful:
Dell R910
Xeon E7-8837 @ 2.67GHz, RAM 64GB
Windows Server 2016 Standard 64-bit
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
RAID PERC-H700, 10 SSD INTEL 200GB
RAID1 2*200GB - system
RAID1 2*200Gb - tempdb
RAID0 3*200Gb - data
RAID0 3*200Gb - log
Zero raids As long as there are no additional disks, there will be RAID10.
There is a query that performs a SELECT. As a result, T30 executes the request for 00:02:40, and R910 for 00:07:50. The bases are the same.
I just can't understand why a weaker server executes requests faster.
UPD.
Zabbix has a template for MSSQL2012. Now compared both servers at performance of request. I got the following data:
Average SQLServer:Access Methods: Workfiles Created/sec {MS SQL 2012:perf_counter["\SQLServer:Access Methods\Workfiles Created/sec",30].last()}>20 rises to 70 (against 0 ,8 on T30)
Average SQLServer:Access Methods: Worktables Created/sec {MS SQL 2012:perf_counter["\SQLServer:Access Methods\Worktables Created/sec",30].last()}>20 rises to 180 (against 6 .5 on T30)
Average SQLServer:Access Methods Page Splits / Sec {MS SQL 2012:perf_counter["\SQLServer:Access Methods\Page Splits/sec",30].last()}>{MS SQL 2012:perf_counter["\SQLServer:SQL Statistics \Batch Requests/sec",30].last()}/5 goes up to 60 (against 2.3 on T30)

Answer 1

why a weaker server executes requests faster

- SSDs in RAID 1 are slower than without it;
- a "weak" server has a higher frequency.
And, of course, before comparing, you need to defragment the indexes and reset the query cache. Since the version of MS SQL Server is not specified, I cannot recommend the optimization snap-in.