Why is remote scan

• Simon Su

  Mr or Mrs. 500

  Points: 558

  More actions

  April 10, 2014 at 4:04 am

  #287516

  I run the following statement in my local machine:

  select top 10 * from sys.dm_os_performance_counters;

  and I find the execute plan is Remote Scan. I am confused about this. Could anyone tell me why?

  Thank you in advance.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 10, 2014 at 4:09 am

  #1704818

  It's just how many of the DMVs are implemented, using a mechanism kinda like a linked server. Don't worry about it.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Simon Su

  Mr or Mrs. 500

  Points: 558

  More actions

  April 10, 2014 at 4:17 am

  #1704821

  THANK YOU, Gail.