Silicon Valley Code Camp : October 5th and 6th 2013session
A SQL Server performance warehouse using the SSAS tabular model
About This Session
What if you could take performance data related to SQL Server (and we'll touch on non-SQL Server sources as well) and collect it into a data warehouse that's implemented using the SQL 2012 SSAS Tabular Model? You'd be able to build virtually an infinite number of reports using tools such as Excel 2010+. You'd be able to consolidate different kinds of metrics and define your own KPI's. In this session I'll show you the work I've done to accomplish this, codified in the SQL-Hero product. You'll understand the concepts involved so you can roll your own solutions, or you'll see enough to get up-and-running quickly if you choose to use SQL-Hero. Along the way, you'll also learn about SSAS, PowerPivot and DAX; plus we'll touch on SQL Server Extended Events and some handy DMV queries.