Author: SQL Server Engineering Team

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are getting ready to update the SQL Server Management Packs. This includes the existing versioned MPs for 2008-2016, as well as the new version agnostic SQL Server MP for 2012 and up (for more info on the version agnostic MP, see here). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better. Please download at: Microsoft System Center Management Packs (Community Technical Preview) for SQL Server 2008-2016 Microsoft System ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. The SQL Server team is excited to bring you SQL Server 2014 Service Pack 3 (SP3). SQL Server 2014 SP3 contains 25+ improvements centered around performance, scalability and diagnostics based on the feedback from customers and SQL community. These improvements enable SQL Server 2014 to perform faster and scale out of the box on modern hardware design. It also showcases the SQL Product Team’s commitment to provide continued value into in-market releases. Additional Release information found in KB4022619. Following is the detailed list of improvements introduced in SQL 2014 SP3 ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. On September 28, 2017 we announced the Modern Servicing Model for SQL Server.  In that announcement, we made reference to two changes in SQL Server 2017 servicing: SQL Server 2017 Cumulative Updates (CU) will be released monthly for the 1st year, and quarterly from then on during Mainstream support phase CU Slipstream Media, similar to previous SQL Server version Service Pack (SP) Slipstream media, will be provided for SQL Server 2017 CU12 Changes we are announcing today:  Starting with SQL Server 2017, Cumulative Updates released after the first year will have ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are happy to announce that Management Packs for SQL Server 2017 Analysis Services and Reporting Services are released. Please download at: Version Agnostic SSAS and SSRS MPs As you might recall, we introduced version agnostic MPs starting with SQL Server 2017. We are now doing the same for SSAS and SSRS. We understand that with many SQL Server versions in market and with new server releases becoming more frequent, it is becoming harder to manage a separate MP for each server version. We are moving to version agnostic MPs to address ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are adding support in the existing version agnostic SQL Server MP (2017+) to monitor older versions of the server, specifically 2012 through 2016. SQL Server 2008 and R2 end of support is nearing (July 2019) so we will leave monitoring 2008 in its own MP. This is an update to the public preview we released earlier this year (release blog post). Please refer to that blog post for that release on the details of planned changes as it involves some naming changes and impacts custom MPs. Please install and use this ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. On Tuesday August 14 we published a Security Update for six different releases of SQL Server 2016 and 2017. For one of those releases, SQL Server 2016 SP1 GDR (KB4293801), an issue may occur after applying the update where the sqlceip.exe process experiences an unhandled exception.  This will only occur if the updated instance was currently configured to collect SQL  Customer Experience Improvement Program (CEIP) information. This does not impact the operation of the updated SQL Server engine, however this may impact a SQL Server Failover Cluster Instance node if ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We moved to version agnostic management packs with SQL Server 2017+ MP. That is, 2017+ MP is built to monitor SQL Server versions 2017 and up.  We had announced that the current in-market MPs (2008 through 2016) were not being changed and the 2017+ MP could not be used to monitor older releases. We would like to now add support in the version agnostic MP to monitor older versions of the server, specifically 2012 through 2016. SQL Server 2008 and R2 end of support is nearing (July 2019) so we ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are getting ready to release brand new management packs for SQL Server Analysis Services and SQL Server Reporting Services 2017. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better. Please download at: Microsoft System Center Management Packs (Community Technology Preview) for SQL Server 2017+ Reporting Services and Analysis Services Version Agnostic SSAS and SSRS MPs As you might recall, we introduced version agnostic MPs starting with SQL Server ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are happy to announce that updates to SQL Server (2008-2017+), Analysis Services, and Reporting Services (2008-2016) Management Packs have been released. Downloads available: Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server Database Engines, Databases, SQL Server Agents, and other related components. Microsoft System Center Management Pack for SQL Server 2017+ Microsoft System Center Management Pack for SQL Server 2016 Microsoft System Center Management Pack for SQL Server 2014 Microsoft System Center Management Pack for SQL Server (2008-2012) Management Pack for SQL Server Analysis ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are getting ready to update the SQL Server and SQL Server Reporting Services Management Packs. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better. Please download at: Microsoft System Center Management Packs (Community Technical Preview) for SQL Server Microsoft System Center Management Pack (Community Technology Preview) for SQL Server 2017+ Microsoft System Center Management Packs (Community Technology Preview) for SQL Server 2008-2016 Reporting Services (Native Mode) New ... Read More