Being presented for the PASS BI Virtual chapter.
Data Warehouse load patterns, schema design and queries are all different than OLTP systems, so shouldn’t your storage solution be different too? This session will look at both physical and logical disk layout and their effects on Data Warehouse performance. We will discuss a number of disk related technical jargon and acronyms. We will demystify some of those, understand where to look to find bottlenecks, understand your SAN and, most importantly, why you care about disk performance. To tie all of these parts together we will touch upon partitioning, compression and monitoring topics that SQL Server 2008 offers. When you are done with this session, you will be able to not only understand your SAN administrator, but they will understand you as well. You will be empowered with some recommendations for effective, real world tested, disk layouts for warehouse storage!