Analysis Services 2008 R2 Performance Guide is already released

Blog Archive

►

2011

►

October

► Analysis Services 2008 R2 Performance Guide is already released

►

July

► SQL Server Denali CTP 3 available to download with new features in Analysis Services and Powerpivot
► Assign bucket types dynamically with MDX and dynamic sets in Analysis Services

►

2010

►

November

► Mejorando el rendimiento de la visualización de dimensiones configurando el DEFAULTMEASURE del cubo (SSAS)

About this blog

Ruben Pertusa Lopez

Data Platform Engineer

Business Intelligence

rpertusa@solidq.com

View in Web Browser

/rpertusa/_layouts/VisioWebAccess/VisioWebAccess.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1

0x0

0x1

FileType

vdw

255

Manage Subscriptions

/_layouts/images/ReportServer/Manage_Subscription.gif

/rpertusa/_layouts/ReportServer/ManageSubscriptions.aspx?list={ListId}&ID={ItemId}

0x80

0x0

FileType

rdl

350

Manage Data Sources

/rpertusa/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

rdl

351

Manage Shared Datasets

/rpertusa/_layouts/ReportServer/DatasetList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

rdl

352

Manage Parameters

/rpertusa/_layouts/ReportServer/ParameterList.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

353

Manage Processing Options

/rpertusa/_layouts/ReportServer/ReportExecution.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

354

Manage Cache Refresh Plans

/rpertusa/_layouts/ReportServer/CacheRefreshPlanList.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

355

View Report History

/rpertusa/_layouts/ReportServer/ReportHistory.aspx?list={ListId}&ID={ItemId}

0x0

0x40

FileType

rdl

356

View Dependent Items

/rpertusa/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsds

350

Edit Data Source Definition

/rpertusa/_layouts/ReportServer/SharedDataSource.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsds

351

View Dependent Items

/rpertusa/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

smdl

350

Manage Clickthrough Reports

/rpertusa/_layouts/ReportServer/ModelClickThrough.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

smdl

352

Manage Model Item Security

/rpertusa/_layouts/ReportServer/ModelItemSecurity.aspx?list={ListId}&ID={ItemId}

0x0

0x2000000

FileType

smdl

353

Regenerate Model

/rpertusa/_layouts/ReportServer/GenerateModel.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

smdl

354

Manage Data Sources

/rpertusa/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

smdl

351

Load in Report Builder

/rpertusa/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderModelContext&list={ListId}&ID={ItemId}

0x0

0x2

FileType

smdl

250

Edit in Report Builder

/_layouts/images/ReportServer/EditReport.gif

/rpertusa/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderReportContext&list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

250

Edit in Report Builder

/rpertusa/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderDatasetContext&list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsd

250

Manage Caching Options

/rpertusa/_layouts/ReportServer/DatasetCachingOptions.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsd

350

Manage Cache Refresh Plans

/rpertusa/_layouts/ReportServer/CacheRefreshPlanList.aspx?list={ListId}&ID={ItemId}&IsDataset=true

0x0

0x4

FileType

rsd

351

Manage Data Sources

/rpertusa/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

rsd

352

View Dependent Items

/rpertusa/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsd

353

Edit in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1&Edit=1

0x0

0x25

FileType

xlsx

256

Edit in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1&Edit=1

0x0

0x25

FileType

xlsm

256

Edit in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1&Edit=1

0x0

0x25

FileType

xlsb

256

Edit in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=EditView&PresentationId={ItemUrl}&source={Source}

0x0

0x4

FileType

pptx

256

Edit in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=EditView&PresentationId={ItemUrl}&source={Source}

0x0

0x4

FileType

ppsx

256

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

docx

255

Edit in Browser

{SiteUrl}/_layouts/WordEditor.aspx?id={ItemUrl}&source={Source}

0x0

0x4

FileType

docx

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

doc

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

dotx

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

dot

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

dotm

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

docm

255

Edit in Browser

{SiteUrl}/_layouts/WordEditor.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

docm

255

View in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=0&source={Source}

0x0

0x1

FileType

one

255

Edit in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=1&source={Source}

0x0

0x4

FileType

one

255

View in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=0&source={Source}

0x0

0x1

ProgId

OneNote.Notebook

252

Edit in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=1&source={Source}

0x0

0x4

ProgId

OneNote.Notebook

254

Compliance Details

javascript:commonShowModalDialog('{SiteUrl}/_layouts/itemexpiration.aspx?ID={ItemId}&List={ListId}', 'center:1;dialogHeight:500px;dialogWidth:500px;resizable:yes;status:no;location:no;menubar:no;help:no', function GotoPageAfterClose(pageid){if(pageid == 'hold') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/hold.aspx?ID={ItemId}&List={ListId}'); return false;} if(pageid == 'audit') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/Reporting.aspx?Category=Auditing&backtype=item&ID={ItemId}&List={ListId}'); return false;} if(pageid == 'config') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/expirationconfig.aspx?ID={ItemId}&List={ListId}'); return false;}}, null); return false;

0x0

0x1

ContentType

0x01

898

Edit in Browser

/_layouts/images/icxddoc.gif

/rpertusa/_layouts/formserver.aspx?XsnLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

FileType

xsn

255

Edit in Browser

/_layouts/images/icxddoc.gif

/rpertusa/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document

255

Edit in Browser

/_layouts/images/icxddoc.gif

/rpertusa/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.2

255

Edit in Browser

/_layouts/images/icxddoc.gif

/rpertusa/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.3

255

Edit in Browser

/_layouts/images/icxddoc.gif

/rpertusa/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.4

255

View in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsx

255

View in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsm

255

View in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsb

255

View in Browser

/rpertusa/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

ods

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pptx

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

ppt

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pptm

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

ppsx

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

ppsm

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pps

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

potx

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

potm

255

View in Browser

/rpertusa/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pot

255

Document Set Version History

javascript:SP.UI.ModalDialog.ShowPopupDialog('{SiteUrl}/_layouts/DocSetVersions.aspx?List={ListId}&ID={ItemId}')

0x0

ContentType

0x0120D520

330

Send To other location

javascript:GoToPage('{SiteUrl}/_layouts/docsetsend.aspx?List={ListId}&ID={ItemId}')

0x0

ContentType

0x0120D520

350

Analysis Services 2008 R2 Performance Guide is already released

2011-10-11 11:51:32 by Rubén Pertusa López

The new version of the Analysis Services Performance Guide is now out for the version of Microsoft SQL Server Analysis Services 2008 R2.

This is a “must read” whitepaper for all SSAS developers and administrators where we can check out all the best practices of processing, querying and designing solutions in SSAS.

Download the Analysis Services 2008 R2 Performance Guide

By the way, you can find below the latests whitepapers around Analysis Services:

Download the Analysis Services 2008 R2 Operations Guide

Download the Analysis Services 2008 Performance Guide (not R2)

Rubén Pertusa (rpertusa@solidq.com); Twitter: @rpertusa

Comments

No Comments