Policy management

10 Jul 2009 6:08 AM

Abba

Hello,

[SQL2008]

Iam trying to evaluate Policy management feature.

(1) There are number of policies that are shipped with Microsoft SQLServer.
I tried "database auto close" policy and purposefully, put one database in
auto close=true. Then scheduled the policy and specified the job to email
the output to me. Manually started the job and the it gave this output:

ID Policy Name                    Result Start Date         End Date
-- -----------                    ------ ----------         --------
1 Database Auto Close            False 7/9/2009 10:52 PM 7/9/2009 10:52 PM

Question: From this, how will someone know which database is set to auto
close=true?

(2) There is a provision to schedule the policy run when run against a
individual server as I mentioned above. But how can I schedule 1 or more
policies to be run against a collection of servers? I configured CMS and
added my list of servers under it, but there is no option to schedule a
policy run.

I researched and found http://epmframework.codeplex.com/ but their project
will not work against my CMS as I have already installed SQL2008 SP1 and do
not intend to uninstall it.

TIA,
AbbA

10 Jul 2009 7:31 AM

Tibor Karaszi

Abba,

1.Go to the server, right-click he policy and either "Evaluate" or
"View history".

2. Import the policies to the servers in question.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quoteHide quote

"Abba" <SQL_H***@aaa.com> wrote in message
news:%234Fz%23TSAKHA.3432@TK2MSFTNGP02.phx.gbl...
> Hello,
>
> [SQL2008]
>
> Iam trying to evaluate Policy management feature.
>
> (1) There are number of policies that are shipped with Microsoft
> SQLServer. I tried "database auto close" policy and purposefully,
> put one database in auto close=true. Then scheduled the policy and
> specified the job to email the output to me. Manually started the
> job and the it gave this output:
>
> ID Policy Name                    Result Start Date         End Date
> -- -----------                    ------ ----------         --------
> 1 Database Auto Close            False 7/9/2009 10:52 PM 7/9/2009
> 10:52 PM
>
> Question: From this, how will someone know which database is set to
> auto close=true?
>
>
> (2) There is a provision to schedule the policy run when run against
> a individual server as I mentioned above. But how can I schedule 1
> or more policies to be run against a collection of servers? I
> configured CMS and added my list of servers under it, but there is
> no option to schedule a policy run.
>
> I researched and found http://epmframework.codeplex.com/ but their
> project will not work against my CMS as I have already installed
> SQL2008 SP1 and do not intend to uninstall it.
>
>
> TIA,
> AbbA
>
>

10 Jul 2009 8:00 AM

Abba

Tibor,

(1) The "View history" is blank. There is nothing written under "message". I
checked the job history and found a probable reason:

Message
WARNING: column "Messages" does not fit into the display and was removed.

Apart from that, shouldn't the output include the object name as well? If I
have a large number of databases, after I get the job output email, it would
be easy to directly go to the database, analyse, and make the change. After
I get the job output via email, if I had to come back to the policy and
select 'evaluate' to find out the database name, why should I schedule the
policy in the first place?

(2) So this means that for scheduling the policy execution, my target
SQLServers should be in SQL2008.

Thank you,
AbbA

Show quoteHide quote

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:%23yzGuBTAKHA.1340@TK2MSFTNGP05.phx.gbl...
> Abba,
>
> 1.Go to the server, right-click he policy and either "Evaluate" or "View
> history".
>
> 2. Import the policies to the servers in question.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Abba" <SQL_H***@aaa.com> wrote in message
> news:%234Fz%23TSAKHA.3432@TK2MSFTNGP02.phx.gbl...
>> Hello,
>>
>> [SQL2008]
>>
>> Iam trying to evaluate Policy management feature.
>>
>> (1) There are number of policies that are shipped with Microsoft
>> SQLServer. I tried "database auto close" policy and purposefully, put one
>> database in auto close=true. Then scheduled the policy and specified the
>> job to email the output to me. Manually started the job and the it gave
>> this output:
>>
>> ID Policy Name                    Result Start Date         End Date
>> -- -----------                    ------ ----------         --------
>> 1 Database Auto Close            False 7/9/2009 10:52 PM 7/9/2009 10:52
>> PM
>>
>> Question: From this, how will someone know which database is set to auto
>> close=true?
>>
>>
>> (2) There is a provision to schedule the policy run when run against a
>> individual server as I mentioned above. But how can I schedule 1 or more
>> policies to be run against a collection of servers? I configured CMS and
>> added my list of servers under it, but there is no option to schedule a
>> policy run.
>>
>> I researched and found http://epmframework.codeplex.com/ but their
>> project will not work against my CMS as I have already installed SQL2008
>> SP1 and do not intend to uninstall it.
>>
>>
>> TIA,
>> AbbA
>>
>>
>

10 Jul 2009 9:36 AM

Tibor Karaszi

> (1) The "View history" is blank. There is nothing written under
> "message". I checked the job history and found a probable reason:
>
> Message
> WARNING: column "Messages" does not fit into the display and was
> removed.

Hmm, that job message I haven't encountered before. Yes, that seems to
be a possible reason for history not to show. Seems to be by design,
but you could always open a case at connect.microsoft.com and see what
MS have to say about it.

> Apart from that, shouldn't the output include the object name as
> well?

I agree. Again, connect time.

> (2) So this means that for scheduling the policy execution, my
> target SQLServers should be in SQL2008.

Correct.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quoteHide quote

"Abba" <SQL_H***@aaa.com> wrote in message
news:uEKksSTAKHA.3708@TK2MSFTNGP02.phx.gbl...
> Tibor,
>
> (1) The "View history" is blank. There is nothing written under
> "message". I checked the job history and found a probable reason:
>
> Message
> WARNING: column "Messages" does not fit into the display and was
> removed.
>
> Apart from that, shouldn't the output include the object name as
> well? If I have a large number of databases, after I get the job
> output email, it would be easy to directly go to the database,
> analyse, and make the change. After I get the job output via email,
> if I had to come back to the policy and select 'evaluate' to find
> out the database name, why should I schedule the policy in the first
> place?
>
>
> (2) So this means that for scheduling the policy execution, my
> target SQLServers should be in SQL2008.
>
> Thank you,
> AbbA
>
> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com>
> wrote in message news:%23yzGuBTAKHA.1340@TK2MSFTNGP05.phx.gbl...
>> Abba,
>>
>> 1.Go to the server, right-click he policy and either "Evaluate" or
>> "View history".
>>
>> 2. Import the policies to the servers in question.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "Abba" <SQL_H***@aaa.com> wrote in message
>> news:%234Fz%23TSAKHA.3432@TK2MSFTNGP02.phx.gbl...
>>> Hello,
>>>
>>> [SQL2008]
>>>
>>> Iam trying to evaluate Policy management feature.
>>>
>>> (1) There are number of policies that are shipped with Microsoft
>>> SQLServer. I tried "database auto close" policy and purposefully,
>>> put one database in auto close=true. Then scheduled the policy and
>>> specified the job to email the output to me. Manually started the
>>> job and the it gave this output:
>>>
>>> ID Policy Name                    Result Start Date         End
>>> Date
>>> -- -----------                    ------ ----------         --------
>>> 1 Database Auto Close            False 7/9/2009 10:52 PM
>>> 7/9/2009 10:52 PM
>>>
>>> Question: From this, how will someone know which database is set
>>> to auto close=true?
>>>
>>>
>>> (2) There is a provision to schedule the policy run when run
>>> against a individual server as I mentioned above. But how can I
>>> schedule 1 or more policies to be run against a collection of
>>> servers? I configured CMS and added my list of servers under it,
>>> but there is no option to schedule a policy run.
>>>
>>> I researched and found http://epmframework.codeplex.com/ but their
>>> project will not work against my CMS as I have already installed
>>> SQL2008 SP1 and do not intend to uninstall it.
>>>
>>>
>>> TIA,
>>> AbbA
>>>
>>>
>>
>
>