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