Thursday, February 07, 2013 4:34 AMcan anyone tell me how to optimize a cube? r techniques ?
- Moved by SSISJoostMicrosoft Community Contributor Thursday, February 07, 2013 5:30 AM Not SSIS related
Thursday, February 07, 2013 4:53 AM
These links will give basics:
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.
Monday, February 11, 2013 1:44 PMModerator
can anyone tell me how to optimize a cube? r techniques ?
I recommend you refer to the following articles:
Analysis Services 2008 R2 Performance Guide: http://sqlcat.com/sqlcat/b/whitepapers/archive/2011/10/10/analysis-services-2008-r2-performance-guide.aspx
Analysis Services Query Performance Top 10 Best Practices: http://msdn.microsoft.com/en-us/library/cc966527.aspx
Performance Tuning Large Analysis Services Cubes: http://sqlbits.com/Sessions/Event8/Performance_Tuning_Large_Analysis_Services_Cubes
In addition, SQL Server Profiler tracks engine process events, such as the start of a batch or a transaction, and it captures data about those events, thus enabling you to monitor server and database activity (for example, user queries or login activity). For detail information, please see:
Use SQL Server Profiler to Monitor Analysis Services: http://technet.microsoft.com/en-us/library/ms174946.aspx
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 19, 2013 4:45 AM