topic Re: Just a helpful SAP note for slow SQL statements in Application Development and Automation Discussions

Just a helpful SAP note for slow SQL statements

Former Member — Sun, 12 Apr 2009 14:27:43 GMT

Hi Guys,

Just wanted to share this SAP note with you. I am sure many of you might have gone through it.

[SAP Note 155413 - Analysis of slow SQL statements|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=155413]

Cheers,

Abu

Re: Just a helpful SAP note for slow SQL statements

Former Member — Wed, 15 Apr 2009 06:37:22 GMT

.... it was not updated since 2002 ... so very restricted in usefulness

Please read my blog on the SQL Trace, I know it is short, but it contains a lot of things.

Read section 3 and 4, the display in section 3 was not available in 2002, it is much more powerful

than the normal tracelist. If you read section 3 and 4 carefully then you will be able to find most

performance issuses on the db.

The way to remove them is not explained there, it will be explained somewhere else, unfortunately not in six pages

Siegfried

Re: Just a helpful SAP note for slow SQL statements

Former Member — Wed, 15 Apr 2009 06:41:22 GMT


> Hi Guys,
> 
> Just wanted to share this SAP note with you. I am sure many of you might have gone through it. 
> 
> [SAP Note 155413 - Analysis of slow SQL statements|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=155413]
> 
> Cheers,
> Abu

Hi,

I would bet not as many as you might think - many questions here suffering form not GOING through

the analysis before they post it here.

Meantime I think questions to SQL statement performance here will only be answered when the execution plan on the statement is posted with it.

bye

Re: Just a helpful SAP note for slow SQL statements

HermannGahm — Wed, 15 Apr 2009 07:35:12 GMT

Hi YukonKid,

Execution Plan AND... statement, variables, indexes, statistics... and the ST05 runtime figures THAT would be nice if that would be posted with the sql statements... sigh.

Kind regards,

Hermann

Re: Just a helpful SAP note for slow SQL statements

Former Member — Wed, 15 Apr 2009 07:45:15 GMT

> Meantime I think questions to SQL statement performance here will only be answered when the

> execution plan on the statement is posted with it.

but you know the execution plan of a Z-table is useless ...

Very often I would be happy if only the relevant line of the summary would be provided, many people have no performance problem, they read just too much ... or they mix up disk times with time from cache.

Siegfried

Re: Just a helpful SAP note for slow SQL statements

Former Member — Thu, 16 Apr 2009 07:11:25 GMT


> 
> Very often I would be happy if only the relevant line of the summary would be provided, many people have no performance problem, they read just too much ... or they mix up disk times with time from cache.
> 
> Siegfried

Hi Siegfried,

wich complies to my 1st rule of SQL access : The fastest way to do something, is not doing it at all...

bye