Identify CPU intensive queries currently running RRS feed

  • Question

  • Hi,
    We are on Sql Server 2014 enterprise. 
    Recently on our production box, we noticed CPU spiked at 98% for around 4 hours. 
    At any point in time on our server, there are a number of sql batches that run.

    So in a situation like this where the CPU is at 98% and there are 100s of Sql queries running, how do we identify queries that are CPU intensive?

    Any Suggestions, please?

    Wednesday, August 31, 2016 12:59 AM