Syntax error on executing this Performance tuning query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Syntax error on executing this Performance...

Syntax error on executing this Performance tuning query

Rate Topic

Display Mode

Topic Options

Author

Message

jaiganesh-489973

Posted Saturday, March 15, 2008 4:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 16, 2009 8:46 AM
Points: 4, Visits: 55

Hi guys,

I am executing this query in the query analyzer 2005.I am the sysadmin to the server.
when I executed this query it errored with a syntax error as highlighted in red . please help me

syntax error
Server: Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '.'.

select top 10 qs.sql_handle, qs.execution_count
, qs.total_elapsed_time, qs.last_elapsed_time
, qs.min_elapsed_time, qs.max_elapsed_time

, qs.total_clr_time, qs.last_clr_time
, qs.min_clr_time, qs.max_clr_time
, substring(st.text, (qs.statement_start_offset/2)+1
, ((case qs.statement_end_offset
when -1 then datalength(st.text)
else qs.statement_end_offset
end - qs.statement_start_offset)/2) + 1) as statement_text
from sys.dm_exec_query_stats as qs
[color=red] cross apply sys.dm_exec_sql_text(qs.sql_handle) as st[/color]

Post #469908

RBarryYoung

Posted Saturday, March 15, 2008 5:12 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

FYI, you have to quote the color, "red" in the color tag.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #469912

RBarryYoung

Posted Saturday, March 15, 2008 5:16 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

Huh, it works just fine for me.

Are you sure the is SQL Server 2005? Is the database possibly in compatibility mode=80?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #469913

GilaMonster

Posted Sunday, March 16, 2008 6:58 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099, Visits: 30,392

Probably compatability mode. What do the following queries return?

SELECT @@version

exec sp_dbcmptlevel < Name of the database you're in >

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #469983

« Prev Topic | Next Topic »

Permissions