SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2008 Policy-Based Management


SQL Server 2008 Policy-Based Management

Author
Message
Jayakumar Krishnan
Jayakumar Krishnan
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1448 Visits: 809
Thanks for your Questions and clarifications... Special thanks to Steve...

Still lot of tricks to learn in PBM, will post it soon...

Thanks
Jay
www.sqldbops.com

Thanks
Jay
http://www.sqldbops.com
Sqlchicken
Sqlchicken
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 Visits: 671
Steve Jones - Editor (1/18/2010)
Jorge,
looking forward to the book

Perhaps you and your authors want to send in a few questions.


Thank you very much! I just submitted a couple of ones I think you guys will enjoy :-P

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
OCTom
OCTom
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4159 Visits: 4152
Thanks Steve for the explanation. I thought I over-thought. :-D
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26203 Visits: 12506
A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
- and that was last updated as recently as November 2009.

Tom

Sqlchicken
Sqlchicken
Mr or Mrs. 500
Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)Mr or Mrs. 500 (573 reputation)

Group: General Forum Members
Points: 573 Visits: 671
Tom.Thomson (2/12/2010)
A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
- and that was last updated as recently as November 2009.


Actually to add to your excitement, that line is a little misleading. Not only can you manage your 2008 instances but you can manage your 2000, 2005 instances as well as Express/Standard/Enterprise editions. The only caveat is that because some features didn't exist is down-level versions (i.e. no DMV's in 2000, no filestream in anything less than 2008) your policies may not work. In order to get around that when you build a policy you can do an edition restriction and specify a policy to only apply to whichever version/edition you'd like.

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26203 Visits: 12506
Jorge Segarra (2/14/2010)
Actually to add to your excitement, that line is a little misleading.
Yes, that's what I meant when I said MS must have forgotten to change BOL.

Tom

Peter Trast
Peter Trast
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1074 Visits: 655
Tom.Thomson (2/12/2010)
A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
- and that was last updated as recently as November 2009.

Great question, I am glad it came up. I just taught an upgrade class from 2005 to 2008 and BOL had also led me to believe that PBM was for 2008 only. I should have looked a little deeper I guess :-D

At least I have another selling point for my customers who are considering upgrading!

Keep 'em coming!

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Jayakumar Krishnan
Jayakumar Krishnan
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1448 Visits: 809
Thanks and I've written another article about evaluating policies on mutliple instances (SQL 2008 , 2005 and 2000), that will be published end of this month, I hope that will be more fun... :-)

Thanks
Jay
http://www.sqldbops.com
Paul White
Paul White
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: General Forum Members
Points: 36136 Visits: 11361
Tough question for one measly little point.



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Jayakumar Krishnan
Jayakumar Krishnan
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1448 Visits: 809
Hope this would be useful for all...

http://www.sqlservercentral.com/articles/Policy-Based+Management/69587/

Thanks
Jay
http://www.sqldbops.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search