我有两个服务器运行相同的SQL查询。查询在一台服务器上运行良好,但在另一台服务器上运行时间太长(37秒)。我打开了统计数据,得到了以下结果:SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 0 ms.服务器2:(这需要37
记录将有具有总cpu的服务器和具有cpu测试的虚拟服务器。server, total cpu, assigned cpu, free cpusrv2, 15, 14, 1select servername, sum(cpu_count) as cpu_allocated
from cpuallocation where se