Tag Archives: practices

SSAS Performance – Best Practices and Performance Optimization

Optimizations of SSAS Cubes SSAS – Best Practices and Performance Optimization – Part 1 of 4 http://www.mssqltips.com/sqlservertip/2565/ssas–best-practices-and-performance-optimization–part-1-of-4/ Performance optimization techniques for source system design and network settings 1. To avoid more locks or lock escalations, you can specify the TABLOCK … Continue reading

Posted in SQL Server | Tagged , , | Comments Off on SSAS Performance – Best Practices and Performance Optimization