ssas

All Replies

• Thursday, February 07, 2013 4:53 AM

   

   
  

  0

  These links will give basics:

  http://www.mssqltips.com/sqlservertip/2565/ssas--best-practices-and-performance-optimization--part-1-of-4/

  http://msdn.microsoft.com/en-us/library/aa902649(v=sql.80).aspx

  Regards,Eshwar.

  ---

  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.

  • Proposed As Answer by Bharath_RAM Thursday, February 07, 2013 5:50 AM
  • Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 19, 2013 4:45 AM
  •  
  • Reply
  • Quote

   
• Monday, February 11, 2013 1:44 PM

  Moderator

   

   
  

  0

  can anyone tell me how to optimize a cube? r techniques ?

  Hi aveshskhasim,

  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

  Regards,

  ---

  Elvis Long
  TechNet Community Support

  

  • Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 19, 2013 4:45 AM
  •  
  • Reply
  • Quote