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 (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 The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
