We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE: [sap-basis] Detected cause of system-slow-down and how to solve it?

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by D. Caddick (SAP NetWeaver/BASIS Consultant)
on Dec 6 at 2:55 AM 		Mark this reply as helpfulMark as helpful
Hi Didik,

It is a normal process to sometimes add additional indexes especially after an upgrade. SAP does not automatically create all your secondary indexes.

Use TX SM50 to determine which table you see a lot of sequential reads, and taking a long time. Double click on the process and you will see the SQL statement and first check that the table statistics are up to date and then see if an optimal index exists.

Regards

---------------Original Message---------------
From: Didik Bhudi
Sent: Sunday, December 05, 2010 9:12 PM
Subject: Detected cause of system-slow-down and how to solve it?

Hi Chris,

Creating index is sometimes fast solution (providing you know which field
need to be indexed)

but normally SAP will take care of this (which field of table need to be
indexed)

if I were you, I will double check and asking confirmation from SAP Support
for necessity of indexing the field.

another thing normally creating index will increase index table space
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. Caddick
SAP Basis Top Contributor

Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
Related Content
Most Popular White Papers
In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language