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. ---------------------------------------------------------------------
