Valid CPU speed comparison?

• RVO

  SSCertifiable

  Points: 5495

  More actions

  January 4, 2017 at 10:03 am

  #325030

  Hi all,

  all our environments are on Virtual Machines.

  We are using SQL Server 2014 SP1.

  I noticed that if I run same performance test script

  in all environments (PROD/UAT/QA), the results are almost identical.

  env------min:sec

  ----------------------

  PROD:---2:48

  UAT:-----2:38

  QA:------2:36

  local sql: 0:12

  What does it mean?

  CPU resource is evenly distributed for all VM's ?

  Also a question is: Is it a valid comparison?

  ----TEST SCRIPT----

  declare @number float

  declare @Result float

  set @number = 0

  while @number <= 17000000

  begin

  set @Result = @number * 1.003

  set @number = @number + 1

  end

  See the attachments for results...

  What is also interesting when I run this same script on my local SQL Server

  it runs 8-10 times faster !??

  I realize my local SQL is not busy at all but still... isn't it strange?