1 Reply Latest reply on Sep 22, 2016 10:22 AM by sqlrockstar

    Using DPA to mine the plan cache for query costs

    jrb2971

      I would love some help trying to add a metric to keep track of query costs.  My ultimate goal is to be able to trend the cost value so I can set the cost for parallelism.

      I heard this doesn't exist out of the box.  I guess I need to track down the tsql needed to capture the information and figure out how to add it to some DPA metric.

       

      Thanks for anyone that has any info on this. sqlrockstar