program run for long time in qas

[Former Member]

Dear all,

I met difficulties while executing an ABAP program in our QAS system, it runs for long time and finally dump (4-5 hours), the same code in PRD only takes about 10 seconds to completed.

I tried to check the index on the sap standard table but seems to be exactly the same.

Could any experts suggest possible causes?

Thank you so much.

[Former Member · Accepted solution]

Hi

Try to rebuild the indexes relagted to ABAP program.Some time high fragmentation could also hurt the performance.

list out here your further findings also

Thanks

Mushtaq

[Former Member · Accepted solution]

Hello all,

Thank you for your replies.

are there any third party tools provided by SAP like BRTOOLS for oracle to manage MSSQLSERVER?

For example, if I need to enlarge the data file, is it possible for me to do it at SAP frontend by tcode? or I must do it at database server side to manage it within SQL Server Enterprise Manager under windows OS?

Thank you in advance.

[Former Member · Accepted solution]

Except DBA cockpit for monitoring, SAP did not provide any other tools as of i know.

for any changes and regular maintenance task i use SQL Server management studio, including extending datafiles, backup, DB consistency etc..

Thanks

Mushtaq

[Former Member · Accepted solution]

thanks to all

problem finally solved.

1. extend datafile and 2. rebuild index

[markus_doehr2]

- Is the hardware identical and is it identically configured (database cache, SAP buffers etc.)?

- Are the database statistics up-to-date on the QAS system (reflecting the content of the tables)?

- Is the amount of data to be read the same?

Markus