DBCC SHOW_STATISTICS WITH HISTOGRAM_STEPS run on remote linked servers

• KATHLEEN Y ZHANG

  Hall of Fame

  Points: 3534

  More actions

  May 16, 2008 at 12:13 pm

  #187760

  I am seeing a lot of like this

  DBCC SHOW_STATISTICS(N'"myDB"."dbo"."myTable"',"Index4") WITH HISTOGRAM_STEPS

  running on remote linked servers and it seems to be causing some performance problems. We have a lot of remote queries.

  Does anyone know what this does?

  Thanks!

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  May 16, 2008 at 12:46 pm

  #816679

  Yeah, that shows the distribution of the stats on that index. I don't know why someone would be running that as much as you're reporting though.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: