Analysis Services 2008 R2 Operations Guide

giugno 02, 2011

Microsoft ha reso disponibile un nuovo ed interessantissimo whitepaper dedicato ad Analysis Services 2008 R2 (ma assolutamente fruibile anche da chi usare le versione 2005 o 2008), che è un must-read per tutti coloro che lavorano con SSAS:

The Analysis Services 2008R2 Operations Guide

Di seguito un’estratto degli argomenti:

Memory Configuration
Thread Pool and CPU Configuration
Partitioning, Storage Provisioning and Striping
Performance Monitor
Dynamic Management Views
Profiler Traces
Data Collection Checklist
Monitoring and Configuring Memory
Monitoring and Tuning I/O and File System Caches
Monitoring the Network
Testing Analysis Services Cubes
Firewalling the Server
Encrypting Transmissions on the Network
Encrypting Cube Files
Securing the Service Account and Segregation of Duties
File System Permissions
High Availability and Disaster Recovery
Backup/Restore
Clustered Servers
Tuning Processing Data
Tuning Process Index
Tuning Queries
Locking and Blocking
Scale Out
Server Maintenance
Special Considerations
Distinct Count