Presenter: Ted Malone
http://portal.sqltrainer.com
One of the problems that presents those new to Business Intelligence development is how to configure the development and production environments for maximum efficiency. This session will cover the installation and configuration of SSAS for both development and production environments. Attendees will leave this session with a good understanding of the options available and the specific needs in an SSAS environment.
Haha. Beer can aerodynamics analogy. Funny!
Better in 2008
- Innovative Cube Designer
- Best practice design alerts
- Enhanced dimension designs
- Enhanced aggregation designs
I like Ted. Introducing his dog via desktop picture. Nikki?
Installation
- Two important things to SSAS
- Memory (RAM)
- I/O
- Separate channel for your OLAP data
- Add new features to existing SQL Server 2008 instance
- Add SSAS
- Service Accounts
- Generally speaking: Use a domain service account (Check Carl Dubler’s guide)
- Add current user to the Administrators role
- Data Directories tab
- Move folders into the appropriate locations based upon I/O channel decisions
- Proceed with the installation process.
Introduces new dog. Sasha! hehe
Configuration (In SSMS)
- Properties of Instance
- Log\FlightRecorder
- Captures trace info if stuff goes wrong
- Enabled by default
- FlightRecorderCurrrent.trc file
- Memory
- Personally Ted hates dynamic memory allocation.
- If SQLServer and Analysis Services installed on the same box, you must set limits on SQL Server Memory
- Books Online actually is very good on this topic
- Planning & Architecture -> Physical Architecture topics are the ones
- Set Low Memory Limit to 50% – Not a best practice but allows you to look at profiler, services, process and determine how to proceed.
- While publishing cube, watch the msmdsrv.exe process to see memory utilization.
- Log\FlightRecorder
Books Online. Books Online. Books Online.
Popularity: 11% [?]
