The Art of War-Fast Track Data Warehouse & Fragmentation
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy.
Know your enemy.
Learn all about fragmentation - from the inside out. Let's get back to brass tacks and understand how SQL Server handles heaps and clustered indexes, re-visit page allocation and then apply this knowledge to our understanding of fragmentation. We will conclude by looking at some design patterns to help you minimise the impact of fragmentation on your next data warehousing project.
Key topics presented:
- Logical, extent and file fragmentation
- Heap and clustered index architecture and internals
- Page allocation - how it works and how to influence it
- Trace flags that help avoid fragmentation
- Fragmentation in action
- Design patterns for minimal fragmentation
Cheers, JRJ
- Downloads
- SpeakerBIO
James is a SQL Server Consultant and Microsoft MVP. His focus and passion is to architect and deliver highly scalable database systems that are creative,simple and elegant in their design. He has worked for some of the worlds largest institutions and been responsible for project delivery across EMEA. James has worked on both OLTP and BI/data warehouse engagements and latterly has been spending a lot of time working on SQL Server reference architectures and appliances including Fast Track and PDW.
James is a keen advocate for the SQL Server community both internationally and here in the UK. He is a member of the SQLBits Organising Committee and co-founder of SQLSocial.com. Recently James was appointed as a Board Advisor to PASS. He is charged with providing an international perspective to the board across a wide variety of matters but primarily to assist the PASS community grow internationally.
You can find James on twitter
@jrowlandjones or
www.linkedin.com
- Video
- Session Files Explorer
The network name cannot be found.