X hits on this document

141 views

0 shares

0 downloads

0 comments

7 / 48

Big PeopleSoft Deployment (cont)

PSFT software does produce considerable number of Adhoc-Statements

Caused a lot of CPU consumption by compilations in the past

SQL Server 2005 ‘Forced Parameterization’ recommended to be used with PSFT. Showed very good performance increases w/o negative impacts so far

PSFT customers of larger size reported problems of blocking lock scenarios between modifiers and committed readers

RCSI did resolve the problem and enabled better scalability

However this increased the load on tempdb. Hence more disks needed for tempdb.

DBA-416M• ISV configurations & implementations – Lessons Learned

Document info
Document views141
Page views141
Page last viewedWed Jan 18 09:59:10 UTC 2017
Pages48
Paragraphs862
Words4327

Comments