topic EarlyWatch - Expensive SQL Statements help in Application Development and Automation Discussions

EarlyWatch - Expensive SQL Statements help

Former Member — Mon, 19 Nov 2007 12:20:55 GMT

Hi all,

i need to analyze an EWA report and i don't know how exactly can i identify an "expensive SQL statement".

The report says:

During this session, the following expensive SQL statements were identified as causing a database load of at least 1%.

The corresponding stored procedure names are referenced in the table below.

And in the table with stored procedure names, a row looks like this:

ID Stored Procedure Name

1 ##Y4DCWWES7EHY100000053960000254832042037

What does it mean and how can i identify the name of program and the exact statement (probably select) that is causing this problem?

Thank you,

Ondrej

Re: EarlyWatch - Expensive SQL Statements help

Former Member — Mon, 19 Nov 2007 18:38:13 GMT

Hi Ondrej,

you're running on SQL Server. SAP creates stored procedures for each and every statement run against the database. The name you get seems to be a temporary stored procedure which (if I'm not wrong) is marked by the two # characters at the beginning. You may be still find it in the stored procedures of your system.

Open the Enterprise Manager and open your database, then the stored procedure link (you should run the Enterprise Manager on the server or on a PC with enough RAM). The search for the procedure and double click on it. I think that should show you the SQL statement. There should also the report name is a comment.

Regards

Ralph