Post reply

Incorrect syntax near '.'

  • November 18, 2013 at 3:00 am

    #282645

    I have just copied following query from 'Scripts' from our site only. when i execute it i get Error : Incorrect syntax near '.'

    i dont know anything about this query. I just wanted to see my top 5 executing queries.

    SELECT TOP 5 SQLtxt.text AS 'SQL',

    qstats.execution_count

    AS 'Execution Count',

    qstats.total_logical_writes/DATEDIFF(second, qstats.creation_time,

    GetDate()) AS 'Logical Writes Per Second',

    qstats.total_physical_reads AS [Total Physical Reads],

    qstats.total_worker_time/qstats.execution_count AS [Average WorkerTime],

    qstats.total_worker_time AS 'Total Worker Time',

    DATEDIFF(hour, qstats.creation_time,

    GetDate()) AS 'TimeInCache in Hours'

    FROM sys.dm_exec_query_stats AS qstats

    CROSS APPLY sys.dm_exec_sql_text(qstats.sql_handle) AS SQLtxt

    WHERE SQLtxt.dbid = db_id()

    ORDER BY qstats.execution_count DESC

    I have sql 2008 R2.

    pls help

  • November 18, 2013 at 3:21 am

    #1667063

    Nothing wrong with that query. Let me guess, you're running it from a database with compatibility level set to 80. If that's the case, change the database context to master and change the filter on databaseID to a fixed value, that of the database you're interested in.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 18, 2013 at 3:31 am

    #1667064

    done.

    thanks man, you are always a life saver....:-)

  • November 18, 2013 at 3:40 am

    #1667066

    KcV (11/18/2013)

    done.

    thanks man, you are always a life saver....:-)

    Although the avatar is a bit misleading, Gail is a woman 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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