So How Does BI Workload Impact the Database Engine? Part I
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.