Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Identifying Queries Running Slower Than Normal Expand / Collapse
Author
Message
Posted Wednesday, August 06, 2008 9:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 3:05 AM
Points: 48, Visits: 833
Comments posted to this topic are about the item Identifying Queries Running Slower Than Normal
Post #547985
Posted Thursday, August 07, 2008 12:28 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,181, Visits: 1,368
Something wrong, not able to read the article...


Post #548020
Posted Thursday, August 07, 2008 12:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 07, 2008 1:00 AM
Points: 1, Visits: 5
Yes

But the word doc file is legible (although the file name is missing the .doc extension!)
Post #548024
Posted Thursday, August 07, 2008 1:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 3:05 AM
Points: 48, Visits: 833
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
Post #548043
Posted Thursday, August 07, 2008 2:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 1:46 AM
Points: 268, Visits: 707
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'.
Post #548083
Posted Thursday, August 07, 2008 2:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 26, 2011 2:28 AM
Points: 1, Visits: 11
HI there,

I have the same error mentioned above.

Regards
Post #548085
Posted Thursday, August 07, 2008 3:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 07, 2008 8:47 AM
Points: 1, Visits: 4
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'.
Post #548093
Posted Thursday, August 07, 2008 3:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 3:05 AM
Points: 48, Visits: 833
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
Post #548097
Posted Thursday, August 07, 2008 3:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 3:05 AM
Points: 48, Visits: 833
Hi,

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

Thanks
Ian
Post #548099
Posted Thursday, August 07, 2008 3:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 07, 2008 5:25 AM
Points: 2, Visits: 3
I get error when running query:

"Divide by zero error encountered.
The statement has been terminated."

Any ideas?
Post #548101
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse