Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance Dashboard: Unique Compiles Expand / Collapse
Author
Message
Posted Friday, January 11, 2008 11:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 57, Visits: 206
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



Post #441941
Posted Thursday, October 25, 2012 1:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 6, 2013 11:16 PM
Points: 1, Visits: 101
Hi everyone,
I have the same question regarding the "Unique Compiles" column - what is its purpose.
Thanks
Post #1376823
Posted Thursday, October 25, 2012 4:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 2,836, Visits: 3,952
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
Post #1376892
Posted Thursday, October 25, 2012 4:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 826, Visits: 2,671




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1376907
Posted Monday, November 5, 2012 3:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:34 AM
Points: 23, Visits: 128
U CAN REFER THE FOLLOWING ATTACHMENT



  Post Attachments 
Data_Management_Framework_Administration_Guide.pdf (33 views, 1.97 MB)
Post #1380962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse