Identifying Queries Running Slower Than Normal

Question

Post reply

Identifying Queries Running Slower Than Normal

ianstirk

Ten Centuries

Points: 1310
More actions
August 6, 2008 at 9:22 pm

#195352

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

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

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

Anipaul SSC-Insane Points: 24681 More actions · Answer 1

Anipaul

SSC-Insane

Points: 24681

August 7, 2008 at 12:28 am

#854224

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

chris fewtrell Grasshopper Points: 17 More actions · Answer 2

Yes

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

ianstirk Ten Centuries Points: 1310 More actions · Answer 3

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: 4591 More actions · Answer 4

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 More actions · Answer 5

HI there,

I have the same error mentioned above.

Regards

Maciej-450894 SSC Rookie Points: 27 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

Hi,

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

Thanks

Ian

Nicola Harding SSC Enthusiast Points: 102 More actions · Answer 9

I get error when running query:

"Divide by zero error encountered.

The statement has been terminated."

Any ideas?

sbateman-803743 SSC Veteran Points: 222 More actions · Answer 10

I get [NULL] in 'DataBaseName' column

SQL:[2005]

Otherwise v.useful.tool

khushbu SSCarpal Tunnel Points: 4591 More actions · Answer 11

Hi Ian

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

Also can you brief us about DMV.

Thanks

Sean Fackrell-465713 Old Hand Points: 336 More actions · Answer 12

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

Mark Taylor-212571 Ten Centuries Points: 1196 More actions · Answer 13

Mark Taylor-212571

Ten Centuries

Points: 1196

August 7, 2008 at 5:55 am

#854373

Is there an equivalent for SQL Server 2000?

PHIL WOOD SSC Rookie Points: 44 More actions · Answer 14

PHIL WOOD

SSC Rookie

Points: 44

August 7, 2008 at 6:14 am

#854382

Somebody wake me up when the proc is useable.