I have a SQL Server 2016 instance and a MySQL instance, where both are on seperate VMs running on the SAME physical server. The MySQL is linked to SQL Server.

My question is, what are possible latency causes for the data transfer? I ran a query on MySQL that executed in 9 seconds. The same query I ran via Linked Server in SSMS (using OPEN QUERY) and that took 56 seconds to execute.

I am trying to pinpoint the causes of the lag to fix this before scaling! All opinions and suggestions are greatly appreciated.

  • How many rows are involved? Perhaps the rows are shoveled across the "link" one row at a time. – Rick James Jan 19 '17 at 23:54
  • in total, id say around 10 million in total (sum of rows from all tables) – choloboy Jan 20 '17 at 0:05
  • Adding the query to your question could be helpful. Also, do you have the latest and greatest driver installed and properly configured on the SQL Server box? One last question: do you really have a need to pull 10 million rows every time this query runs? – SQL_Deadwood Jan 20 '17 at 3:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.