Home Forums SQL Server 2008 SQL Server 2008 - General Query To Find CPU Usage for Indvidual Adhoc query and a sproc RE: Query To Find CPU Usage for Indvidual Adhoc query and a sproc

  • February 22, 2017 at 5:38 pm

    #1929878

    curious_sqldba - Wednesday, February 22, 2017 12:44 PM

    John Mitchell-245523 - Wednesday, February 22, 2017 9:17 AM

    Not sure I understand.  Does this help?  You'd have to add a where clause looking for your query text in the "text" column.

    John

    Thanks. Doesn't rollup to stored procedure. I am stress testing a stored procedure, i am trying to find how much CPU is it using.

    Take a look at sys.dm_exec_procedure_stats.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning