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 query hint while querying or ALLOW_ROW_LOCKS = OFF and ALLOW_PAGE_LOCKS = OFF when creating tables […]