Simple counting query is slow in SQL Server on one VM but not others
I am investigating an issue with one of our SQL Server 2017 instances where a simple counting query runs extremely slow on one server only but runs fine on all of our other SQL instances. I found the following SQL from Microsoft that is meant to test CPU speeds
(https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-perf-between-servers#diagnose-environment-differences)