• Hi Gail, I ran this query.

    select

    highest_cpu_queries.plan_handle,

    highest_cpu_queries.total_worker_time,

    q.dbid,

    q.objectid,

    q.number,

    q.encrypted,

    q.[text]

    from

    (select top 50

    qs.plan_handle,

    qs.total_worker_time

    from

    sys.dm_exec_query_stats qs

    order by qs.total_worker_time desc) as highest_cpu_queries

    cross apply sys.dm_exec_sql_text(plan_handle) as q

    order by highest_cpu_queries.total_worker_time desc

    as of now, it is occupying top slot instead of 7th position.



    Pradeep Singh