Identifying Queries Running Slower Than Normal

  • ianstirk

    Ten Centuries

    Points: 1310

    Comments posted to this topic are about the item Identifying Queries Running Slower Than Normal

  • Anipaul

    SSC-Insane

    Points: 24681

    Something wrong, not able to read the article...

  • chris fewtrell

    Grasshopper

    Points: 17

    Yes

    But the word doc file is legible (although the file name is missing the .doc extension!)

  • ianstirk

    Ten Centuries

    Points: 1310

    Hi,

    There is a formatting problem with the SQL displayed on the main page.

    Please see the associated resources document ‘Identifying queries running slower than normal-SSC.doc’, this has the correctly formatted SQL at the end of the article.

    Hopefully the website editor will correct the main display soon.

    Thanks

    Ian

  • khushbu

    SSCarpal Tunnel

    Points: 4387

    Hi

    I got error while exec the query

    Im on SQL 2005 Sp2

    Msg 170, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 43

    Line 43: Incorrect syntax near 'MAX'.

    Msg 156, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 97

    Incorrect syntax near the keyword 'END'.

  • eloi.guterres

    SSC Rookie

    Points: 25

    HI there,

    I have the same error mentioned above.

    Regards

  • Maciej-450894

    SSC Rookie

    Points: 27

    I have the same message on SQl Server 2000

    Msg 170, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 43

    Line 43: Incorrect syntax near 'MAX'.

    Msg 156, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 97

    Incorrect syntax near the keyword 'END'.

  • ianstirk

    Ten Centuries

    Points: 1310

    Hi,

    Copy the SQL given at the end of the Word document 'Identifying queries running slower than normal-SSC.doc'. It might be worthwhile copying the SQL into Notepad first to remove any ‘bad’ characters.

    Hope this helps

    Ian

  • ianstirk

    Ten Centuries

    Points: 1310

    Hi,

    This routine will NOT work on SQL Server 2000, it uses DMVs.

    Thanks

    Ian

  • Nicola Harding

    SSC Enthusiast

    Points: 102

    I get error when running query:

    "Divide by zero error encountered.

    The statement has been terminated."

    Any ideas?

  • sbateman-803743

    SSC Veteran

    Points: 222

    I get [NULL] in 'DataBaseName' column

    SQL:[2005]

    Otherwise v.useful.tool

  • khushbu

    SSCarpal Tunnel

    Points: 4387

    Hi Ian

    Can we have similar kinda query/SP for SQL 2000.

    Also can you brief us about DMV.

    Thanks

  • Sean Fackrell-465713

    SSC Enthusiast

    Points: 196

    Copying the SQL directly from the Word document worked for me and it's very useful. Thanks!

  • Mark Taylor-212571

    Ten Centuries

    Points: 1136

    Is there an equivalent for SQL Server 2000?

  • PHIL WOOD

    SSC Rookie

    Points: 44

    Somebody wake me up when the proc is useable.

Viewing 15 posts - 1 through 15 (of 58 total)

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