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...
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.
Edited by: Kaushal Malavia on Oct 8, 2008 4:26 PM