Transcript Third-party applications Reporting Services Excel Data model Multidimensional Tabular MDX DAX Business logic and queries Data access Databases LOB Applications ROLAP Files SharePoint Insights PowerPivot MOLAP OData Feeds xVelocity VertiPaq Direct Query Cloud Services Sales Sales 2,000,000,000 Dictionary Col.

Third-party
applications
Reporting
Services
Excel
Data model
Multidimensional
Tabular
MDX
DAX
Business logic
and queries
Data access
Databases
LOB Applications
ROLAP
Files
SharePoint
Insights
PowerPivot
MOLAP
OData Feeds
xVelocity
VertiPaq
Direct
Query
Cloud Services
Sales
Sales
1
1
2,000,000,000
2
Dictionary
Col. Segment
P2
Partition 1
Partition 1
Partition 2
Split
DB1
DB2
DB1~
New, not
committed
part of the
database
FE
VertiPaq
caches
VertiPaq Query Performance
Scans @ 5B+ rows/s
1B+ rows of data
Scans @ 20B+ rows/s
10B+ rows of data
DAX/MDX
VertiPaq Query
Vertipaq  Performance, Performance, Performance
Amdahl's law: Establishes the
maximum expected improvement
to an overall system when only
part of the system is improved.
The speedup of a program using
multiple processors in parallel
computing is limited by the time
needed for the sequential fraction
of the program.
DBI61-HOL: Developing a Tabular BISM Using SQL Server Data Tools
Microsoft SQL Server: Breakthrough Insights - Credible, Consistent Data
• http://www.powerpivotblog.nl/
/what-is-using-all-that-memory-on-my-analysis-server-instance
/bismservermemoryreport
• http://www.powerpivotblog.nl/wp-content
/uploads/2012/02/BISMServerMemoryReport.xlsx
• http://www.powerpivotblog.nl/?s=BISMServerMemory
SQL Server 2012
Eval Copy
Hands-On Labs
mva
Get Certified!
@sqlserver
@ms_teched
http://europe.msteched.com
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
http://europe.msteched.com/sessions