X hits on this document

123 views

0 shares

0 downloads

0 comments

13 / 48

Australian Tax Office – Siebel implementation (cont)

Tempdb developed as bottleneck in two areas:

Mixed extent allocations

Internal administration pages as GAM, SGAM, IAM, PFS

Solutions:

Use trace flag 1118 to avoid mixed extent allocations

Described in KBA 328551 for SQL2000. Also valid for SQL2005



Use 10 data files for tempdb in order to fan out allocations over different administration pages in different GAM intervals

EMC SRDF/A Asynchronous Storage Replication does honor all requirements of SQL Server I/O basics

Usability and distance of usability solely dependent on network throughput and quality

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

Document info
Document views123
Page views123
Page last viewedSat Dec 10 13:26:16 UTC 2016
Pages48
Paragraphs862
Words4327

Comments