X hits on this document

146 views

0 shares

0 downloads

0 comments

12 / 48

Australian Tax Office – Siebel implementation (cont)

Database has 26 data files spread over 7 LUNs

Uneven mapping to LUNs due to usage of file groups

Siebel allows usage of file groups – Usage is customer individual

Effort in balancing I/O workloads to different LUNs

No general recommendations for Siebel since file groups can be very customer specific

Usually highly write intensive staging tables for data import in own file group

Siebel released upgrade scripts might need to be changed in order to accommodate individual file group

Fan-out of Siebel staging tables on multiple files within a file group reduces latch contention on SQL Server’s internal administration pages

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

Document info
Document views146
Page views146
Page last viewedThu Jan 19 09:00:54 UTC 2017
Pages48
Paragraphs862
Words4327

Comments