RE: [EXTERNAL] [mssms] Database compatibility

2017-03-22 Thread Heaton, Joseph@Wildlife 
Thanks everyone!  I’ll leave the CM_ database at 110, and bump the others up to 
120.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Sherry Kissinger
Sent: Wednesday, March 22, 2017 7:06 AM
To: mssms@lists.myitforum.com
Subject: Re: [EXTERNAL] [mssms] Database compatibility

To be clear, I meant the db's he mentioned:  ReportServer, the report server 
temp, and the SUSDB
We're on SQL 2016, latest CU.  All our databases for "just about" everything 
are 2016 compat--except the CAS itself (yes, we have a CAS, sadly, with ~400k 
devices, we have to).  After flipping it to sql 2016 everything was great 
except for 1 thing:  For people who go into the console and do NOT have 
security scope to "everything"--in the console, where it would display "just 
the stuff scoped to you", i.e., in Applications; that would take 5+ minutes to 
return results.  If you were full-on admin to everything everywhere, it was 
normal (a few seconds).  As soon as we flipped it to SQL Server 2012 Compat, it 
was back to snappy for people with limited security scopes.

So the CAS database, and the CAS alone is sql 2012 (110); when running SQL 2016.
The SUSdb, the primary sites' databases, the mp replica databases, etc., 
--those are all 2016 compat.

If you happen to be in an environment where everyone in the console is full 
admin, you could have your database for CM (hopefully you don't have a CAS, 
just your 1 primary) with sql 2016 be compat of 2016; and you'd never notice 
this issue.  But if you have RBA and security scopes, you'll want to test that 
scenario if/when you move to sql 2016.

On Wed, Mar 22, 2017 at 8:38 AM, Daniel Ratliff 
<dratl...@humana.com<mailto:dratl...@humana.com>> wrote:
Can confirm. All our servers are on SQL 2014, with Compat of 120. Our CM 
database is on 110. No issues here.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Sherry Kissinger
Sent: Wednesday, March 22, 2017 9:01 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [EXTERNAL] [mssms] Database compatibility

Sure; change them to the highest compatibility.  If you encounter issues (we 
didn't) but if you did, it's a quick flip back.

On Tue, Mar 21, 2017 at 5:11 PM, Heaton, Joseph@Wildlife 
<joseph.hea...@wildlife.ca.gov<mailto:joseph.hea...@wildlife.ca.gov>> wrote:
So, my CM_ database ended up being correct.  The ones that are not, are 
ReportServer, the report server temp, and the SUSDB.  Worth changing?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Jason Wallace
Sent: Tuesday, March 21, 2017 12:55 PM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [EXTERNAL] [mssms] Database compatibility


Yes, I have been there and getting this right is like night and day.  From a 
user experience perspective you'll see really horrible Software Center 
performance


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Spengler, Jeff 
<jspeng...@idahopower.com<mailto:jspeng...@idahopower.com>>
Sent: 21 March 2017 19:36
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [EXTERNAL] [mssms] Database compatibility

Take a look at this KB.
https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries
SQL query times out or console slow on certain 
...<https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries>
support.microsoft.com<http://support.microsoft.com>
Describes a scenario in you may experience slow Configuration Manager console 
performance or unusual SQL query timeouts for certain Configuration Manager 
database ...




SQL Server version

Supported compatibility level values

Recommended compatibility level for ConfigMgr

SQL Server 2016

130, 120, 110, 100

130

SQL Server 2014

120, 110, 100

110





From: "listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>" 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of "Heaton, Joseph@Wildlife" 
<joseph.hea...@wildlife.ca.gov<mailto:joseph.hea...@wildlife.ca.gov>>
Reply-To: "mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>" 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Date: Tuesday, March 21, 2017 at 12:14 PM
To: "'mssms@lists.myitforu

Re: [EXTERNAL] [mssms] Database compatibility

2017-03-22 Thread Sherry Kissinger 
To be clear, I meant the db's he mentioned:  ReportServer, the report
server temp, and the SUSDB
We're on SQL 2016, latest CU.  All our databases for "just about"
everything are 2016 compat--except the CAS itself (yes, we have a CAS,
sadly, with ~400k devices, we have to).  After flipping it to sql 2016
everything was great except for 1 thing:  For people who go into the
console and do NOT have security scope to "everything"--in the console,
where it would display "just the stuff scoped to you", i.e., in
Applications; that would take 5+ minutes to return results.  If you were
full-on admin to everything everywhere, it was normal (a few seconds).  As
soon as we flipped it to SQL Server 2012 Compat, it was back to snappy for
people with limited security scopes.

So the CAS database, and the CAS alone is sql 2012 (110); when running SQL
2016.
The SUSdb, the primary sites' databases, the mp replica databases, etc.,
--those are all 2016 compat.

If you happen to be in an environment where everyone in the console is full
admin, you could have your database for CM (hopefully you don't have a CAS,
just your 1 primary) with sql 2016 be compat of 2016; and you'd never
notice this issue.  But if you have RBA and security scopes, you'll want to
test that scenario if/when you move to sql 2016.

On Wed, Mar 22, 2017 at 8:38 AM, Daniel Ratliff <dratl...@humana.com> wrote:

> Can confirm. All our servers are on SQL 2014, with Compat of 120. Our CM
> database is on 110. No issues here.
>
>
>
> *Daniel Ratliff*
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Sherry Kissinger
> *Sent:* Wednesday, March 22, 2017 9:01 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [EXTERNAL] [mssms] Database compatibility
>
>
>
> Sure; change them to the highest compatibility.  If you encounter issues
> (we didn't) but if you did, it's a quick flip back.
>
>
>
> On Tue, Mar 21, 2017 at 5:11 PM, Heaton, Joseph@Wildlife <
> joseph.hea...@wildlife.ca.gov> wrote:
>
> So, my CM_ database ended up being correct.  The ones that are not, are
> ReportServer, the report server temp, and the SUSDB.  Worth changing?
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Jason Wallace
> *Sent:* Tuesday, March 21, 2017 12:55 PM
>
>
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [EXTERNAL] [mssms] Database compatibility
>
>
>
> Yes, I have been there and getting this right is like night and day.  From
> a user experience perspective you'll see really horrible Software Center
> performance
>
>
> --
>
> *From:* listsad...@lists.myitforum.com <listsad...@lists.myitforum.com>
> on behalf of Spengler, Jeff <jspeng...@idahopower.com>
> *Sent:* 21 March 2017 19:36
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [EXTERNAL] [mssms] Database compatibility
>
>
>
> Take a look at this KB.
> https://support.microsoft.com/en-nz/help/3196320/sql-query-
> times-out-or-console-slow-on-certain-configuration-manager-
> database-queries
>
> SQL query times out or console slow on certain ...
> <https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries>
>
> support.microsoft.com
>
> Describes a scenario in you may experience slow Configuration Manager
> console performance or unusual SQL query timeouts for certain Configuration
> Manager database ...
>
>
>
>
> SQL Server version
>
> Supported compatibility level values
>
> Recommended compatibility level for ConfigMgr
>
> SQL Server 2016
>
> 130, 120, 110, 100
>
> 130
>
> SQL Server 2014
>
> 120, 110, 100
>
> 110
>
>
>
>
>
> From: "listsad...@lists.myitforum.com" <listsad...@lists.myitforum.com>
> on behalf of "Heaton, Joseph@Wildlife" <joseph.hea...@wildlife.ca.gov>
> Reply-To: "mssms@lists.myitforum.com" <mssms@lists.myitforum.com>
> Date: Tuesday, March 21, 2017 at 12:14 PM
> To: "'mssms@lists.myitforum.com'" <mssms@lists.myitforum.com>
> Subject: [EXTERNAL] [mssms] Database compatibility
>
> CM1610
> SQL 2014
>
> My SQL Dba just came over and mentioned that my SCCM databases are in 2008
> compatibility mode.  She asked if it would be ok to change that, and I said
> I don’t know.  WSUS is installed on this server as well.  Are there any
> requirements for compatibility mode?  Also, I was told that named pipes are
> disabled.  Any reason/need to have it disabled?
>
> Joe Heaton
> Information Technology Operations Branch
> Data and Technology Divisio

RE: [EXTERNAL] [mssms] Database compatibility

2017-03-22 Thread Daniel Ratliff 
Can confirm. All our servers are on SQL 2014, with Compat of 120. Our CM 
database is on 110. No issues here.

Daniel Ratliff

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Sherry Kissinger
Sent: Wednesday, March 22, 2017 9:01 AM
To: mssms@lists.myitforum.com
Subject: Re: [EXTERNAL] [mssms] Database compatibility

Sure; change them to the highest compatibility.  If you encounter issues (we 
didn't) but if you did, it's a quick flip back.

On Tue, Mar 21, 2017 at 5:11 PM, Heaton, Joseph@Wildlife 
<joseph.hea...@wildlife.ca.gov<mailto:joseph.hea...@wildlife.ca.gov>> wrote:
So, my CM_ database ended up being correct.  The ones that are not, are 
ReportServer, the report server temp, and the SUSDB.  Worth changing?

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Jason Wallace
Sent: Tuesday, March 21, 2017 12:55 PM

To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [EXTERNAL] [mssms] Database compatibility


Yes, I have been there and getting this right is like night and day.  From a 
user experience perspective you'll see really horrible Software Center 
performance


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Spengler, Jeff 
<jspeng...@idahopower.com<mailto:jspeng...@idahopower.com>>
Sent: 21 March 2017 19:36
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [EXTERNAL] [mssms] Database compatibility

Take a look at this KB.
https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries
SQL query times out or console slow on certain 
...<https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries>
support.microsoft.com<http://support.microsoft.com>
Describes a scenario in you may experience slow Configuration Manager console 
performance or unusual SQL query timeouts for certain Configuration Manager 
database ...




SQL Server version

Supported compatibility level values

Recommended compatibility level for ConfigMgr

SQL Server 2016

130, 120, 110, 100

130

SQL Server 2014

120, 110, 100

110





From: "listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>" 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of "Heaton, Joseph@Wildlife" 
<joseph.hea...@wildlife.ca.gov<mailto:joseph.hea...@wildlife.ca.gov>>
Reply-To: "mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>" 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Date: Tuesday, March 21, 2017 at 12:14 PM
To: "'mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>'" 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Subject: [EXTERNAL] [mssms] Database compatibility

CM1610
SQL 2014

My SQL Dba just came over and mentioned that my SCCM databases are in 2008 
compatibility mode.  She asked if it would be ok to change that, and I said I 
don’t know.  WSUS is installed on this server as well.  Are there any 
requirements for compatibility mode?  Also, I was told that named pipes are 
disabled.  Any reason/need to have it disabled?

Joe Heaton
Information Technology Operations Branch
Data and Technology Division
CA Department of Fish and Wildlife
1700 9th Street, 3rd Floor
Sacramento, CA  95811
Desk:  (916) 323-1284<tel:(916)%20323-1284>

Every Californian should conserve water.  Find out how at:
[aveOurWater_Logo]<http://saveourwater.com/>
SaveOurWater.com<http://saveourwater.com/> · 
Drought.CA.gov<http://Drought.CA.gov><http://drought.ca.gov/>
California Drought Portal<http://drought.ca.gov/>
drought.ca.gov<http://drought.ca.gov>
California State Climatologist: Do Not Count on El Niño to End Drought. August 
13, 2015 - State Climatologist Michael Anderson said today that California 
cannot ...


Home - Save Our Water<http://saveourwater.com/>
saveourwater.com<http://saveourwater.com>
Conservation Lifestyle Good Habits. Californians have made great strides in 
their commitment to water conservation and are embracing wise water use as a 
daily habit.





-






This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under

applicable law.  If you are not the intended recipient, you are hereby notified 
that any disclosure, copying,

distribution, or use of the information contained herein

Re: [EXTERNAL] [mssms] Database compatibility

2017-03-22 Thread Sherry Kissinger 
Sure; change them to the highest compatibility.  If you encounter issues
(we didn't) but if you did, it's a quick flip back.

On Tue, Mar 21, 2017 at 5:11 PM, Heaton, Joseph@Wildlife <
joseph.hea...@wildlife.ca.gov> wrote:

> So, my CM_ database ended up being correct.  The ones that are not, are
> ReportServer, the report server temp, and the SUSDB.  Worth changing?
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Jason Wallace
> *Sent:* Tuesday, March 21, 2017 12:55 PM
>
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [EXTERNAL] [mssms] Database compatibility
>
>
>
> Yes, I have been there and getting this right is like night and day.  From
> a user experience perspective you'll see really horrible Software Center
> performance
>
>
> --
>
> *From:* listsad...@lists.myitforum.com <listsad...@lists.myitforum.com>
> on behalf of Spengler, Jeff <jspeng...@idahopower.com>
> *Sent:* 21 March 2017 19:36
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [EXTERNAL] [mssms] Database compatibility
>
>
>
> Take a look at this KB.
> https://support.microsoft.com/en-nz/help/3196320/sql-query-
> times-out-or-console-slow-on-certain-configuration-manager-
> database-queries
>
> SQL query times out or console slow on certain ...
> <https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries>
>
> support.microsoft.com
>
> Describes a scenario in you may experience slow Configuration Manager
> console performance or unusual SQL query timeouts for certain Configuration
> Manager database ...
>
>
>
>
> SQL Server version
>
> Supported compatibility level values
>
> Recommended compatibility level for ConfigMgr
>
> SQL Server 2016
>
> 130, 120, 110, 100
>
> 130
>
> SQL Server 2014
>
> 120, 110, 100
>
> 110
>
>
>
>
>
> From: "listsad...@lists.myitforum.com" <listsad...@lists.myitforum.com>
> on behalf of "Heaton, Joseph@Wildlife" <joseph.hea...@wildlife.ca.gov>
> Reply-To: "mssms@lists.myitforum.com" <mssms@lists.myitforum.com>
> Date: Tuesday, March 21, 2017 at 12:14 PM
> To: "'mssms@lists.myitforum.com'" <mssms@lists.myitforum.com>
> Subject: [EXTERNAL] [mssms] Database compatibility
>
> CM1610
> SQL 2014
>
> My SQL Dba just came over and mentioned that my SCCM databases are in 2008
> compatibility mode.  She asked if it would be ok to change that, and I said
> I don’t know.  WSUS is installed on this server as well.  Are there any
> requirements for compatibility mode?  Also, I was told that named pipes are
> disabled.  Any reason/need to have it disabled?
>
> Joe Heaton
> Information Technology Operations Branch
> Data and Technology Division
> CA Department of Fish and Wildlife
> 1700 9th Street, 3rd Floor
> Sacramento, CA  95811
> Desk:  (916) 323-1284
>
> Every Californian should conserve water.  Find out how at:
> [aveOurWater_Logo]<http://saveourwater.com/>
> SaveOurWater.com<http://saveourwater.com/> · Drought.CA.gov<
> http://drought.ca.gov/>
>
> California Drought Portal <http://drought.ca.gov/>
>
> drought.ca.gov
>
> California State Climatologist: Do Not Count on El Niño to End Drought.
> August 13, 2015 - State Climatologist Michael Anderson said today that
> California cannot ...
>
>
>
> Home - Save Our Water <http://saveourwater.com/>
>
> saveourwater.com
>
> Conservation Lifestyle Good Habits. Californians have made great strides
> in their commitment to water conservation and are embracing wise water use
> as a daily habit.
>
>
>
>
>
> -
>
>
>
>
>
>
> This transmission may contain information that is privileged, confidential
> and/or exempt from disclosure under
>
> applicable law.  If you are not the intended recipient, you are hereby
> notified that any disclosure, copying,
>
> distribution, or use of the information contained herein (including any
> reliance thereon) is STRICTLY PROHIBITED. If
>
> you received this transmission in error, please immediately contact the
> sender and destroy the material in its
>
> entirety, whether in electronic or hard copy format.  Thank you.
>
>
>
> -
>
>
>
>


-- 
Thank you,

Sherry Kissinger

My Parameters:  Standardize. Simplify. Automate
Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger,
http://www.smguru.org

RE: [EXTERNAL] [mssms] Database compatibility

2017-03-21 Thread Heaton, Joseph@Wildlife 
So, my CM_ database ended up being correct.  The ones that are not, are 
ReportServer, the report server temp, and the SUSDB.  Worth changing?

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Jason Wallace
Sent: Tuesday, March 21, 2017 12:55 PM
To: mssms@lists.myitforum.com
Subject: Re: [EXTERNAL] [mssms] Database compatibility


Yes, I have been there and getting this right is like night and day.  From a 
user experience perspective you'll see really horrible Software Center 
performance


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of Spengler, Jeff 
<jspeng...@idahopower.com<mailto:jspeng...@idahopower.com>>
Sent: 21 March 2017 19:36
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: Re: [EXTERNAL] [mssms] Database compatibility

Take a look at this KB.
https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries
SQL query times out or console slow on certain 
...<https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries>
support.microsoft.com
Describes a scenario in you may experience slow Configuration Manager console 
performance or unusual SQL query timeouts for certain Configuration Manager 
database ...




SQL Server version

Supported compatibility level values

Recommended compatibility level for ConfigMgr

SQL Server 2016

130, 120, 110, 100

130

SQL Server 2014

120, 110, 100

110





From: "listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>" 
<listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>> on 
behalf of "Heaton, Joseph@Wildlife" 
<joseph.hea...@wildlife.ca.gov<mailto:joseph.hea...@wildlife.ca.gov>>
Reply-To: "mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>" 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Date: Tuesday, March 21, 2017 at 12:14 PM
To: "'mssms@lists.myitforum.com'" 
<mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>>
Subject: [EXTERNAL] [mssms] Database compatibility

CM1610
SQL 2014

My SQL Dba just came over and mentioned that my SCCM databases are in 2008 
compatibility mode.  She asked if it would be ok to change that, and I said I 
don't know.  WSUS is installed on this server as well.  Are there any 
requirements for compatibility mode?  Also, I was told that named pipes are 
disabled.  Any reason/need to have it disabled?

Joe Heaton
Information Technology Operations Branch
Data and Technology Division
CA Department of Fish and Wildlife
1700 9th Street, 3rd Floor
Sacramento, CA  95811
Desk:  (916) 323-1284

Every Californian should conserve water.  Find out how at:
[aveOurWater_Logo]<http://saveourwater.com/>
SaveOurWater.com<http://saveourwater.com/> · 
Drought.CA.gov<http://drought.ca.gov/>
California Drought Portal<http://drought.ca.gov/>
drought.ca.gov
California State Climatologist: Do Not Count on El Niño to End Drought. August 
13, 2015 - State Climatologist Michael Anderson said today that California 
cannot ...


Home - Save Our Water<http://saveourwater.com/>
saveourwater.com
Conservation Lifestyle Good Habits. Californians have made great strides in 
their commitment to water conservation and are embracing wise water use as a 
daily habit.





-






This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under

applicable law.  If you are not the intended recipient, you are hereby notified 
that any disclosure, copying,

distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If

you received this transmission in error, please immediately contact the sender 
and destroy the material in its

entirety, whether in electronic or hard copy format.  Thank you.



-

Re: [EXTERNAL] [mssms] Database compatibility

2017-03-21 Thread Jason Wallace 
Yes, I have been there and getting this right is like night and day.  From a 
user experience perspective you'll see really horrible Software Center 
performance



From: listsad...@lists.myitforum.com <listsad...@lists.myitforum.com> on behalf 
of Spengler, Jeff <jspeng...@idahopower.com>
Sent: 21 March 2017 19:36
To: mssms@lists.myitforum.com
Subject: Re: [EXTERNAL] [mssms] Database compatibility

Take a look at this KB.
https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries
SQL query times out or console slow on certain 
...<https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries>
support.microsoft.com
Describes a scenario in you may experience slow Configuration Manager console 
performance or unusual SQL query timeouts for certain Configuration Manager 
database ...




SQL Server version

Supported compatibility level values

Recommended compatibility level for ConfigMgr

SQL Server 2016

130, 120, 110, 100

130

SQL Server 2014

120, 110, 100

110





From: "listsad...@lists.myitforum.com" <listsad...@lists.myitforum.com> on 
behalf of "Heaton, Joseph@Wildlife" <joseph.hea...@wildlife.ca.gov>
Reply-To: "mssms@lists.myitforum.com" <mssms@lists.myitforum.com>
Date: Tuesday, March 21, 2017 at 12:14 PM
To: "'mssms@lists.myitforum.com'" <mssms@lists.myitforum.com>
Subject: [EXTERNAL] [mssms] Database compatibility

CM1610
SQL 2014

My SQL Dba just came over and mentioned that my SCCM databases are in 2008 
compatibility mode.  She asked if it would be ok to change that, and I said I 
don’t know.  WSUS is installed on this server as well.  Are there any 
requirements for compatibility mode?  Also, I was told that named pipes are 
disabled.  Any reason/need to have it disabled?

Joe Heaton
Information Technology Operations Branch
Data and Technology Division
CA Department of Fish and Wildlife
1700 9th Street, 3rd Floor
Sacramento, CA  95811
Desk:  (916) 323-1284

Every Californian should conserve water.  Find out how at:
[aveOurWater_Logo]<http://saveourwater.com/>
SaveOurWater.com<http://saveourwater.com/> · 
Drought.CA.gov<http://drought.ca.gov/>
California Drought Portal<http://drought.ca.gov/>
drought.ca.gov
California State Climatologist: Do Not Count on El Niño to End Drought. August 
13, 2015 - State Climatologist Michael Anderson said today that California 
cannot ...


Home - Save Our Water<http://saveourwater.com/>
saveourwater.com
Conservation Lifestyle Good Habits. Californians have made great strides in 
their commitment to water conservation and are embracing wise water use as a 
daily habit.





-






This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under

applicable law.  If you are not the intended recipient, you are hereby notified 
that any disclosure, copying,

distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If

you received this transmission in error, please immediately contact the sender 
and destroy the material in its

entirety, whether in electronic or hard copy format.  Thank you.



-

Re: [EXTERNAL] [mssms] Database compatibility

2017-03-21 Thread Spengler, Jeff 
Take a look at this KB.
https://support.microsoft.com/en-nz/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-database-queries

SQL Server version

Supported compatibility level values

Recommended compatibility level for ConfigMgr

SQL Server 2016

130, 120, 110, 100

130

SQL Server 2014

120, 110, 100

110





From: "listsad...@lists.myitforum.com"  on 
behalf of "Heaton, Joseph@Wildlife" 
Reply-To: "mssms@lists.myitforum.com" 
Date: Tuesday, March 21, 2017 at 12:14 PM
To: "'mssms@lists.myitforum.com'" 
Subject: [EXTERNAL] [mssms] Database compatibility

CM1610
SQL 2014

My SQL Dba just came over and mentioned that my SCCM databases are in 2008 
compatibility mode.  She asked if it would be ok to change that, and I said I 
don’t know.  WSUS is installed on this server as well.  Are there any 
requirements for compatibility mode?  Also, I was told that named pipes are 
disabled.  Any reason/need to have it disabled?

Joe Heaton
Information Technology Operations Branch
Data and Technology Division
CA Department of Fish and Wildlife
1700 9th Street, 3rd Floor
Sacramento, CA  95811
Desk:  (916) 323-1284

Every Californian should conserve water.  Find out how at:
[aveOurWater_Logo]
SaveOurWater.com · 
Drought.CA.gov


-






This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under 

applicable law.  If you are not the intended recipient, you are hereby notified 
that any disclosure, copying, 

distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If 

you received this transmission in error, please immediately contact the sender 
and destroy the material in its 

entirety, whether in electronic or hard copy format.  Thank you.


 
-