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
