X hits on this document

102 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 views102
Page views102
Page last viewedTue Dec 06 20:19:28 UTC 2016
Pages48
Paragraphs862
Words4327

Comments