Performance Issue in Document Management of SAP Solution Manager

[Former Member]

Hi

We have 10k+ documents in our current project and searching any specific document takes time of around 1-2 min. Searching document via SOLAR_EVAL or Menu-->Find Document of Solarxx is giving same output in terms of response time, later being slightly better. Other projects which have comparatively less documents, etc are fine in search response times and other functionalities implemented in system like issue mgmt, etc are also ok in terms of performance.

Can anyone please advice how this performance issue of searching specific document can be resolved?

What first thing which hits me is cleaning SolMan KW and either archiving/deleting old versions of document (because snapshots of every change in single document is stored in solman). If this can really help in making performance better for searching documents, please advice in detail as how this can be done or share any document.

If anyother way this can be achieved, please let me know that also.

Points will be awarded.

Thanks in advance.

Regards,

SM

[Former Member]

Hi Prakhar,

Thanks for your response. And i have been following your replies for lots of other functionalities in SolMan. Appreciate that.

However, I have few queries before going for his program:

1) Is deleting older documents is definitely going to improve response time of searching. You said 'yes' but just wanted to double sure.

2) This program deletes all unsed and de-linked document. I can understand 'De-linked' but not 'Unused'

3) Deleting documents based on user id is big problem. We have almost 800 Users in SolMan, who has used this project form last 5+ years. So all these 800 users have to go into multiple selection of user id

4) I tried this on our sandbox (SP19 Level) which has shown all unused documents which can be deleted. But this deletion has to be done one-by-one. In our production, if we have 10K+ documents, i assume almost thousand or more will be residing as de-linked in KW

5) Any Documentation available on this program.

Regards,

Suchit Malia

[prakhar_saxena]

Hi

1) Is deleting older documents is definitely going to improve response time of searching. You said 'yes' but just wanted to double sure.

Yes

2) This program deletes all unsed and de-linked document. I can understand 'De-linked' but not 'Unused'

i meant the samething

3) Deleting documents based on user id is big problem. We have almost 800 Users in SolMan, who has used this project form last 5+ years. So all these 800 users have to go into multiple selection of user id

Try giving *

4) I tried this on our sandbox (SP19 Level) which has shown all unused documents which can be deleted. But this deletion has to be done one-by-one. In our production, if we have 10K+ documents, i assume almost thousand or more will be residing as de-linked in KW

Try giving *

5) Any Documentation available on this program.

Learnt by experience but you can check some sapnotes below

Note 1124579 - Using SOLMAN_UNUSED_DOCUMENTS to delete unused documents

Note 1377997 - SOLMAN_UNUSED_DOCUMENTS: No deletion conf. for each doc.

Hope above clarifies

Regards

Prakhar

[Former Member]

Hi Prakhar,

Thanks for prompt reply. I can agree to all points but 4. You mean i have to manually delete all unsed documents one-by-one. I just tried this is production with only one user group like 'consultants' but it has given me 1600 Documents. So i think for all users, this will be certainly somewhere between 3-4K. Manual Deletion one-by-one should not be solution.

Regards,

Suchit Malia

[prakhar_saxena]

Hi

Just check this note which i gave you earlier

Note 1377997 - SOLMAN_UNUSED_DOCUMENTS: No deletion conf. for each doc.

Implementation of above note will solve your problem

Regards

Prakhar

Edited by: Prakhar Saxena on May 20, 2011 1:32 PM

[Former Member]

Hi,

OK. Thats sounds logical. So once we implement Note 1377997, mass deletion is possible in one go. right?

Also, other thing is, this program will delete unlinked documents from project. Thats great.

But what about used documents which are currently residing in project and have all their changed snapshots or (say versions) stored in KW. Should that also be archived/deleted for performance tuning?

Regards,

Suchit Malia

[prakhar_saxena]

As I said earlier it will delete only the de-linked documents

[Former Member]

Hi,

Thanks Prakhar for your help and support.

Points Awarded.

Now, i need to come back to my dicussion on Versioning part of documents. Any comments on doing that & is positive impact on current issue.

Regards,

Suchit Malia

[Former Member]

Hi Prakhar,

Please inform if yo uhave any suggestions on archicing/deleting old versions of documents and how can i see those in SAP KW with all detail steps to be followed (as this is entirely new to me).

Thanks

[prakhar_saxena]

Hi

this note might help you

Note 1360988 - Error in the program SOLMAN_DOCU_VERSION_ARCHIVE

if this also doesnt helps you much ...then raise OSS

Regards

Prakhar

[Former Member]

Hi,

Ok..first i will get SAP note implement for deleting unused documents and then will com back to this archiving of old versions. Will take sometime for this in system.

If it works fine, will close the thread but in meantime, if someone else have some other suggestions, please inform.

Thanks.

[Former Member]

Hi,

Same has been done but no improvements in searching performance. Any more suggestions.

Regards,

Suchit

[prakhar_saxena]

HI

Have you used the report SOLMAN_UNUSED_DOCUMENTS this will delete all the unused or de-linked documents from the project and definately remove the unwanted documents increasing your speed.

Hope this helps

Regards

Prakhar