cancel
Showing results for 
Search instead for 
Did you mean: 

Sap System is very slow.

Former Member
0 Kudos

Hi,

We are using IDES system on windows NT and sql server as database.

But the system is very slow ....

I increased the dialog processes from 7 to 12 but there is no use.

Also tried st02 and saw some red alerts so increased the coressponding profile parameters.

Still The system is slow.

Please suggest your ideas.

Thanks,

Sagar.

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member

Hi Sagar,

Check if performance is poor

1. What has changed since the performance is poor?

o

System Parameter Changes (RZ10)?

Increase in the number of users?

Kernel patch?

Support Packages?

Linux and Oracle patches?

Hardware Changes?

2. Any signs of general problems in the System Log - SM21?

3. Places to look:

SM50: u2192 Process u2192 Trace u2192 Components u2013 is there a Trace level set? Is it greater than 1? What is the utilization of the work processes? Click the white clock picture-icon. Is the total CPU for the last dialog process > 10 minutes?

ST04: Is the database monitor activated? If yes, it should deactivated it in normal operation. ST02: Check the buffering quality. If paging occurs in a buffer, the corresponding parameter should be increased. Also refer to SAP Note 121625 in this context.

ST03: u2192 Select a server u2192 Todayu2019s Workload: What are the response times? In the case of poor response times, where is most of the time needed? Button u2018Top Timeu2019: Are there a lot of different transactions with poor response times or are there only a few? Is a certain transaction always slow or only sometimes?

ST06: u2192 Detail analysis menu u2192 Hardware Info. To which extent are the hardware resources utilized? CallST06 at times with poor system performance. What is the CPU utilization? u2192 Goto u2192 Current Data u2192 Snapshot u2192 Top CPU processes and display the main CPU consumers. What is the utilization of the disks? How high is the paging in the base pool?

4. If only few transactions are affected by the performance problem, you should additionally note the following points:

1. Check whether modifications were made in the affected or related transactions.

2. ST03: Display the corresponding performance records.

3. SE30: Carry out a runtime analysis for the affected transactions.

4. ST05: If the database times are high, you should generate an SQL trace of the affected transactions to find out whether the database access is carried out in a useful way.

5. Look for tables that have experienced unusual monthly growth.

1. DB02 u2192 Space Statistics button

2. Press Enter on the Tables and Indexes popup

3. History u2192 All objects off/on

4. Click the Months button

5. Click on the first number under the Rows u2013 Chg/Month header and click the Sort button.

6. The sorted results shows the top tables when it comes to rows changes per month. These tables are your u201Cdatabase hogsu201D.

6. What is considered u201Cnormalu201D response time?

Performance Standards:

Response time u2013 1 second (dialog), /DVEBMGS00/work directory, open a problem with SAP, and attach the zipped file to it. Also provide them with the answers to the above questions as well as your current hardware and database platforms, patch level for SAP support packages, kernel, and the OS, and anything else you might think useful.

The Delicate Art of SAP Note Search

How often have you seen a posted message saying u201CI have searched through SAP Notes and can find nothing related to this matter.u201D? And how often have you gone to SAP Marketplace and done a search yourself and found a hit? If we only had a had a nickleu2026

Searching SAP Notes (formerly known as OSS notes) is a science as well as an art. Lets use this error message as an example:

u201DBR051I BRBACKUP 6.10 (80)

BR055I Start of database backup: bdmsqjbi.anf 2004-02-27 00.05.42

BR602W No valid SAP license found - please contact SAPu201D

First, you should search the specific error message u201CBR602W No valid SAP license foundu201D. If you get at least one hit, you should read the SAP Note even if it didnu2019t look as if it pertained 100%. Why? Because it might contain information leading to other notes that did pertain, or give you new ideas for more search terms to help narrow the scope of my query.

If you didnu2019t find a note that matched the problem, you could make your next search a little less specifc, like u201Cbrbackup No valid SAP license foundu201D. First you could search for the phrase, and if you had no luck, you could search for all words. And if that produced nothing tangible, you could make it even less specific as in u201Cbrbackup SAP license erroru201D or u201CSAP license erroru201D.

Normally a very specific query will get you the results you need. But sometimes things get lost in translation. For example, you are applying support packages and get an import error with the following message u201CPanic! Panic! Panic! thereu2019s no object headeru201D. Since we speak English and we realize that the SAP product was designed and implemented in Germany, we have to guess that the English word u201CPanic!u201D somehow was translated from the German word u201CWarning!u201D and that we can temporarily delay a panick attack until we can research the error. Moral of the story? Realize that some things just donu2019t translate correctly from language to language, and search accordingly. If you searched for u201CPanic! Panic! Panic!u201D and got no hits, you could try u201Cwarning message no object headeru201D.

Last, and not least, read and become familiar with your SAP Notes. There are certain notes that you pull over and over again due to some task that needs fresh, current and precise information. These are mostly lists of supported printer devices, known problems with applying patches, etc.

If a user seems to be experiencing SAPGui errors, several things need to be checked:

u2022 Is the operating system on the useru2019s workstation patched to the level recommended by SAP?

u2022 Is the user using a version of SAPGui that is too old for his workstation?

u2022 Is the user using a version of SAPGui that is not certified for his operating system?

u2022 Is the useru2019s workstation having resource problems?

u2022 Is the useru2019s workstation connected to the LAN?

u2022 Can a different user reproduce the same error on the same workstation?

u2022 Are there any SAPGui patches that have not been applied?

Most SAPGui problems can be solved by either a) deleting and reinstalling SAPGui on the workstation, or b) deleting and installing a newer version of SAPGui.

Make sure that these lines were added to the services file on the useru2019s workstation:

After you have successfully configured your SAPGui, add these three lines to the bottom of your Windowssystem32driversetcservices file:

sapdp00 3200/tcp

sapmsR3I 3600/tcp

#

If you have SAP Instances using System Numbers other than 00, you will have to add their equivalents to the services file as well. Also, check if you are having connection problems due to firewall restrictions. And, be sure that your Insert Key is set so that you can type your password in properly u2013 you can delete whatever is in the password field in order to enter your password.

If you have never tested connectivity to a SAP instance on the workstation having the connection problem, first you need to make sure that the workstation can connect to the SAP server in some non-SAPGui way. Letu2019s say your user us trying to connect to System ID (SID) DEV, System Number 00, and IP address 10.1.10.11. Open a DOS-Windows and type this:

telnet 10.1.10.11 3200¬

If the screen rolls and goes totally blank then your dispatcher is reachable. You can close the DOS session. If your window never goes completely blank and you set a u201CConnecting To 10.1.10.11u2026 Could not open connection to the host, on port 3200: Connect failedu201D error message right under the command you entered, the dispatcher is not reachable. Also, make sure the Windowssystem32driversetchosts file on the workstation is correct.

For information regarding operating system, resource, and hardware requirements for running SAPGui, see SAP Note 26417 -SAP GUI Resources: Hardware and software.

the CUA Parent Client

If CUA stops sending changes from DEV to QAS or PRD, something in the RFC setup has changed. Either the password or the user type for RFC_USER was changed, or the SM59 RFC connection to was changed and is no longer working.

Use SCUL in DEV in your DEV CUA parent to list the errors that are occurring. Look for the user you tried to transport but could not. You might see u201CYou are not authorized to change users in groupu201D or u201CNo authorization for group users in roleu201D. This does not mean that YOU are not authorized, it means that the RFC_USER doing the ALE communication between the SAP systems is not authorized.

First, reset the RFC_USER password in DEV, QAS, and PRD. And make sure that the user type is Communication and not dialog. Now go to sm59 and do remote logins using the QAS RFC connections. If they work (ie nothing seems to happen after you click the remote logon button) everything should now be fixed. If you get a logon screen for QAS, change the password in the sm59 screen to the same password you changed RFC_USER to in DEV and QAS.

Retry your user change. If it still doesnu2019t go to QAS, maybe the QAS system is hosed and down.

________________________________________

Important SAP Marketplace Links

Inbox http://service.sap.com/inbox Read messages from SAP to you

Installation Guides http://service.sap.com/instguides Download SAP product installation

guides

License Keys http://service.sap.com/licensekey Request New Permanent License Key

Messages to SAP http://service.sap.com/message Open problems with SAP

QuickLinks Page http://service.sap.com/quicklinks An index of SAP links

Oracle DBA Page http://service.sap.com/dbaora Page for Oracle DBA Material

OSS Notes http://service.sap.com/notes Search the SAP Notes Database

Patches http://service.sap.com/patches Download SAP software patches

Remote Connection http://service.sap.com/remoteconnection Learn about the OSS connection and

order it from SAP

Service Connection http://service.sap.com/serviceconnection Open a Service Connection for SAP

to access your SAP landscape

Software Distribution http://service.sap.com/swdc Download new images of

Installation CDs & DVDs

SSCR http://service.sap.com/sscr Register Developers and Changes

made against SAP objects

User Administration http://service.sap.com/user-admin Add/Change OSS ID user information

Thanks,

Sandeep

Edited by: BUNTYBASIS on Sep 28, 2011 5:06 PM

ganesh_borase2
Participant
0 Kudos

Hi!,

how much space is available on the database drive?

had you take log backup?

Please try to log backup.

Thanks

GAnesh

Former Member
0 Kudos

Hi,

System Slow is a big Task for a SAP system administrator.

First thing is you see what is that system is doing in SM50 is all the work process occupied?

If occupied then you have to see what activity it is carrying out. ( ex Sequential Read it shows some DB issue or buffer issue)

Then you have to fine tune the System based on this then go to ST03n, ST22, SM21 and find the further cause of the error.

Performance tuning involves tuning of the OS, DB and SAP.

Parallel have a look at ST06 for CPU utilization, CPU ideal time.

Thanks & Regards,

Balaji.S

Former Member
0 Kudos

Sagar,

We had an issue we thought was with memory, but turned out to be with disk drives - look at ST06 and see if you have high utilisation on a particular disk.

It's also worth checking in SM50 to see if you have a lot of items in process or waiting to process.

If you are using SQL, check to see if your database trans log is getting too large or if the database file size has adequate room for growth - ST04 will help

i040689
Advisor
Advisor
0 Kudos

Hi,

also check for high CPU usage, st06

The system displays the current detail data for the largest CPU users, if they choose Detail analysis menu - Goto - Current Data - Snapshot - Top CPU processes in the operating system monitor (see also Detail Data of the Operating System Monitor).

Check the following performance factors in particular:

Display

Procedure

Is a CPU user constantly active?

Check whether the process is in an endless loop.

Is the average load > 3 (more than three processes are waiting for the CPU)?

Check whether all processes with high CPU usage (memlog, r3trans, nwengine, brbackup...) are necessary.

Is the usage of the CPU zero percent?

Check the analysis for the previous hours.

Regards

Adrienne

Former Member
0 Kudos

Hi Sagar,

Try checking the transaction ST03. Check which part consumes most of the time and based on that you can have a better idea to choose...

Regards,

Chandru