SQLBits 2012

So How Does BI Workload Impact the Database Engine? Part I

In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
The use of BI technologies to package and deliver data to business users requires a well-maintained infrastructure to support a demanding workload. In this first of two sessions, SQL Server MVPs  Denny Cherry and Stacia Misner review how the various components fit together and how decisions about where to install each component affect overall performance. We'll also discuss how day-to-day BI operations such as ETL and how to optimize data warehouse load operations.