This Content Component encountered an error
This Content Component encountered an error
This Content Component encountered an error
I'm struggling with some SAP performance issues. We are running SAP R/3 Enterprise version 4.7 on a Windows 2003 Server with MS SQL 2000 (SP 4). When I review SAP stats in ST03, response times seem adequate, buffer and cache hit ratios are over 90% and server memory and CPU don't exceed 20-25%. However, some queries take many minutes. I've run SQL profiler to try and capture some select statements, but we think it could be I/O to the SAN. Management wants to perform a DB "reorg" but I don't know if that is the answer. Do you have any suggestions?
I doubt that this is a SAN problem. If it was, you should have a global performance problem. From the info you gave, it looks like you do not. You should investigate the select statements more closely. Discover which tables and indexes they are using (use transaction ST04 > detailed analysis to do so). Maybe they are not using any index at all. If so, consider creating indexes matching often used selection criteria.

In addition, some indexes might be heavily fragmented; you can use DBCC SHOWCONTIG to verify the fragmentation...

of the indexes. Index fragmentation and what to do about it is explained in detail in the Microsoft TechNet article Index de-fragmentation best practices. It is available at

This was last published in July 2007
This Content Component encountered an error



Find more PRO+ content and other member only offers, here.

This Content Component encountered an error

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.
This Content Component encountered an error