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...

Former Member
Former Member 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