Identifying Queries Running Slower Than Normal

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

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

  • Yes

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

  • 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

  • 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'.

  • HI there,

    I have the same error mentioned above.

    Regards

  • 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'.

  • 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

  • Hi,

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

    Thanks

    Ian

  • I get error when running query:

    "Divide by zero error encountered.

    The statement has been terminated."

    Any ideas?

  • I get [NULL] in 'DataBaseName' column

    SQL:[2005]

    Otherwise v.useful.tool

  • Hi Ian

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

    Also can you brief us about DMV.

    Thanks

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

  • Is there an equivalent for SQL Server 2000?

  • Somebody wake me up when the proc is useable.

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

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