Performance Dashboard: Unique Compiles

• iwaldner

  SSC Eights!

  Points: 805

  More actions

  January 11, 2008 at 11:43 am

  #185424

  In running the Missing Indexes report from the Performance Dashboard I get one which has a very high value in the "Unique Compiles" column. Does anyone know what the "unique compiles" refers to?

  Thanks

  Ilmar

• maria_iva81

  SSC Rookie

  Points: 43

  More actions

  October 25, 2012 at 1:45 am

  #1552541

  Hi everyone,

  I have the same question regarding the "Unique Compiles" column - what is its purpose.

  Thanks

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  October 25, 2012 at 4:32 am

  #1552605

  It means "number of compiles where the index was found missing" see here http://www.freepatentsonline.com/y2007/0130107.html

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  October 25, 2012 at 4:45 am

  #1552619

  

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]

• peterdru401

  Mr or Mrs. 500

  Points: 535

  More actions

  November 5, 2012 at 3:51 am

  #1555951

  U CAN REFER THE FOLLOWING ATTACHMENT