Get Top Queries Taxing SQL Server CPUs

  • Prakash Heda

    SSCertifiable

    Points: 5538

    Comments posted to this topic are about the item Get Top Queries Taxing SQL Server CPUs

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • muthalif

    SSC Rookie

    Points: 27

    Hello Prakash,

    Hope this reply finds you well...

    Thank you very much for the post, by the way I am getting below error.

    Please help me out to correct the same........

    Is ther any setting from my SQL Server SMO to be done ?

    Msg 102, Level 15, State 1, Line 14

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Line 37

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Line 49

    Incorrect syntax near '?'.

  • Prakash Heda

    SSCertifiable

    Points: 5538

    What is the version of SQL server you are using?

    Try commenting the "queryexecuted" column code and run same

    Check this article for how to use this script[/url]:

    Prakash

    http://www.sqlfeatures.com

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • Prakash Heda

    SSCertifiable

    Points: 5538

    Also update declare variable part like below:

    declare @ServerTime datetime , @ConvertMiliSeconds bigint

    , @FilterMoreThanMiliSeconds bigint

    , @FilterHours bigint, @execution_count bigint

    , @debugFlg bit

    select @ServerTime = getdate(),@ConvertMiliSeconds = 1000

    ,@FilterMoreThanMiliSeconds = 1,@FilterHours = 2

    ,@execution_count = 2,@debugFlg bit = 0

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • Prakash Heda

    SSCertifiable

    Points: 5538

    I was able to reproduce the issue

    Seems when one copy the code and run it, it has special character get added due to HTML, invisible though but in windows 2003 notepad and SQL 2012 SSMS editor I was able to see and replace it and than it works, not able to see that character in win7 notepad though.

    let me know if you this doesn't work...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply