SQL Server 2008 Policy-Based Management

Question

Post reply

SQL Server 2008 Policy-Based Management

Jayakumar Krishnan

SSCarpal Tunnel

Points: 4710
More actions
January 17, 2010 at 11:39 am

#215641

Comments posted to this topic are about the item SQL Server 2008 Policy-Based Management
Thanks
Jay
http://www.sqldbops.com

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

SQLWinther SSCertifiable Points: 6294 More actions · Answer 1

Nice question! I learned something from it.

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

learnt some thing. but how does it work?

"Keep Trying"

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

ChiragNS learnt some thing. but how does it work?

These 2 blog poast might help you to learn how it works on 2005 & 2000

http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

OCTom SSChampion Points: 11785 More actions · Answer 4

Did I overthink this? Maybe. What I was think is that if you use 2008 PBM against 2005 or 2008, SQL would be using SMO under the covers and it would therefore, no longer be 2008 PBM. 2000 and 2005 do not have the DB changes necessary to use all of PBM.

Did I overthink it?

Steve Jones - SSC Editor SSC Guru Points: 736193 More actions · Answer 5

You did overthink it. PBM executes basic SQL against all editions. Many of the policy checks in 2008 are SQL as well, so they are the same checks. The things that don't exist in 2000/2005 can't be checked or error out.

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 6

Nice question! Good thing our (Ken Simmons, Colin Stasiuk, myself) book on Policy Based Management (link here) is coming out soon 😉 </shameless plug>

=============================================================
/* 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 Garth SSCertifiable Points: 6193 More actions · Answer 7

Policies are not an item that I have worked with yet, but I do have to pass the #70-432 this year, and I'm sure knowing this is helpful.

Thanks.

Tom Garth
Vertical Solutions[/url]

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

This is good information to know. Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736193 More actions · Answer 9

Jorge,

looking forward to the book

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

Jayakumar Krishnan SSCarpal Tunnel Points: 4710 More actions · Answer 10

Thanks for your Questions and clarifications... Special thanks to Steve...

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

Thanks

Jay

http://www.sqldbops.com

Thanks
Jay
http://www.sqldbops.com

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 11

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 😛

=============================================================
/* 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 SSChampion Points: 11785 More actions · Answer 12

Thanks Steve for the explanation. I thought I over-thought. 😀

TomThomson SSC Guru Points: 104773 More actions · Answer 13

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

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 14

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