Slow Running Query on VM

• vic610

  SSC Veteran

  Points: 203

  More actions

  September 25, 2016 at 8:20 am

  #329973

  Hi All,

  Currently I am having problem with running sql query from one VM to another VM. Here is how I setup the VM.

  I have Dell Server with SSDs Drives and Created 5 virutal server using VMware for Test Environment. For instance, I have VM1, VM2, etc..

  SQL Server 2008 Standard with SP4 on each server. I have done all the link server setup, updated all statistics on each DB on every servers. But query is running very slow in first time!!

  When you run the query again at second time, it runs very fast. Fast time took ages!!

  Here is how I run,

  I am on VM2, open SSMS, then connect to VM1. Run query on SSMS to get data from VM1. It took ages at the first time!!!

  Can you tell me what I missing?

  Remark - I have Live Environment. Everything is the same except, each SQL Servers are on Dedicated Server but all the rest are the same. But it runs very fast even I run the query on the first time.

  I would be appreciated if you can help me.

  Thanks.

• frederico_fonseca

  SSCoach

  Points: 16155

  More actions

  September 25, 2016 at 2:47 pm

  #1903000

  first thing I would look at on a vm environment is to check if both vm host and the vm machines have their power settings to high performance.

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  September 27, 2016 at 4:26 am

  #1903281

  Physical reads.

  Your data is not in memory so it has to go to disk.

  This is even worse if it has to do an index seek or scan and then has to do lookups cos then those will be random physical reads.

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]