Policy-based management almost makes it to AS2008

I was using SQLMS with AS2008 the other day and noticed when right-clicking on the server node in the Object Explorer window some policy-based management options seemed to be available:


Now policy-based management is one of the new features of the relational engine in SQL2008; you can read more about it here:

For a moment I was excited, then I took a look at what facets were actually available for Analysis Services: there’s only one, and that gives you the same options to set as you got in the old Surface Area Configuration tool. Maybe in a future release we’ll get some more functionality – it would be great to be able to enforce policies like "Always associate a partition with an aggregation design" and so on.

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.