August 5, 2011 at 12:21 am
Hi ,
what errors do we face in real time as im new in production side .and how to solve them in SSIS and in SSAS ?
replies are appreciated
August 9, 2011 at 1:46 am
That is a bit of a broad question.
There are thousands of things that can go wrong:
* server has crashed
* database is corrupt
* network is down
* permissions are not set-up correctly
* the wrong SSIS packages were deployed or not deployed at all
* a data quality error leading to a crash in an SSIS package
* bad referential integrity leading to SSAS crashing while processing
* ...
The list is endless.
You'll get to know the common issues and their solutions by experience.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 9, 2011 at 3:25 am
SSIS
missing configuration files , incorrect deployment , missing permissions , networks issues during etl etc.
missing pre reqs
SSAS
Backups , warm cache , performance tuning and memory management during processing. Full processing issues , very large dimensions, Connectivity and security between SSAS and SSRS or excel .
August 11, 2011 at 5:40 am
This almost sounds like an interview question.
Are you a dev dba / BI person that just moved into a production dba position?
Maybe I misunderstood your question, but not all problems in production CAN be resolved with SSIS / SSRS. It's a fallacy to think that they can. Problems need to be resolved through a standard troubleshooting process that has been proven to work. Also, different problems require different troubleshooting procedures.
What exactly are you trying to accomplish by asking this question? And what specifically are you responsible for in your new position?
August 11, 2011 at 6:29 am
Hopefully you have SSAS and SQL on different machines. That can be challenging at times.
And SSAS 2008 seems to handle memory much better.
Opening up a thread detailing a particular problem will get more useful responses.
Also more directed at what might be helpful, rather than just a bunch of random ideas.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply