SSAS Cube Availability While Being Rebuilt
Is a SSAS 2008 cube av开发者_开发技巧ailable to be queried while it's being rebuilt? If yes, then are there implications to querying it during a rebuild?
Yes it is, OLAP will keep a copy until the rebuild has finished. If your rebuild process requires a significantly long downtime then the only implications would be the load placedd on your SQL Server and the freshness of the data being returned by the old copy of your cube.
No, it isn't. There are some features you can utilize to achieve this to varying degrees, but it is far from automatic.
精彩评论