June 2, 2010 at 9:50 am
i am trying gather some info on how do SSAS admin maintain cubes. I would appreciate if someone can share there experience and answer the following questions.
i) what is the schedule to process the cubes? is it done through an agent job?
ii) how to handle performance issues in SSAS
iii) how to setup user permissions in SSAS.
thanks
June 16, 2010 at 10:25 am
These tools I find really useful:
http://bidshelper.codeplex.com/
http://www.mosha.com/msolap/mdxstudio.htm">
http://bidshelper.codeplex.com/
http://www.mosha.com/msolap/mdxstudio.htm
As for schedule, I setup the ETL process to "run every hour" with a check (check_sum) to determine if there is anything to process.
This is done via a SQL agent.
Fortunately the pain of managing permissions has been done by a bespoke .NET service solution (courtesy of our Dev Team) which automatically creates/maintains accounts via AD.
Performance related issues are usually handled by performing a trace in the same way as you would in SQL. A thorough understanding of the cube dimensions and measures usually helps too 🙂
If you retrieve values from your warehouse, I always ensure to SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED to avoid/reduce deadlocking although you run the "minor" risk of "dirty reads" although im sure the good ppl on this forum will advise you different 😉
gsc_dba
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply