Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance tuning

I am in the process of Performance tuning Of EP server 7.0

OS : windows 2003 Ent. version X64 bit

DB : MS sql server 2005

as per the Note 975942, i executed below query.

alter index ALL on EP_PRT_CACHE SET ( ALLOW_PAGE_LOCKS = OFF )

but it throw an error

Msg 1088, Level 16, State 9, Line 2

Cannot find the object "EP_PRT_CACHE" because it does not exist or you do not have permissions.

Please give me the solution...

replied

Hi,

Execute as following

USE SID

alter index ALL on SAP<SID>DB.EP_PRT_CACHE SET ( ALLOW_PAGE_LOCKS = OFF )

where SID = Your sap sysem id in upper case.

regards,

kaushal

Edited by: Kaushal Malavia on Oct 8, 2008 4:26 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question