次の方法で共有

System Center Management Pack for SQL Product Family Community Technology Preview (CTP2)

  • [アーティクル]

UPDATE: Replication MP CTP2 bits are also available on the download page (5/25/2016).

CTP 2 for SQL Management Packs is released!

We are getting ready to release the next versions of SQL Management Packs as well as new MPs for SQL Server 2016. In this Community Technology Preview release, we hope to bring you the changes planned now so that with your feedback we can make the final release the best it can be.

Download center page has the latest CTP bits for each MP. At the download step, you will be able to choose to download only the packages you are interested in.

Please provide feedback either as comments on this page or by emailing SQLMPsfeedback at microsoft.com.

Microsoft System Center Management Packs (Community Technical Preview 2) for SQL Server

Downloads available:

  • Microsoft System Center Management Pack (CTP2) for SQL Server Dashboards (6.7.0.0) This Management Pack supports the Dashboard functionality in SQL Server DB Engine, Analysis Services, Reporting Services and Replication management packs, and enables the creation of user-generated dashboards.
  • Microsoft System Center Management Pack (CTP2) for SQL Server 2005-2012 (6.7.0.0) This Management Pack provides both proactive and reactive monitoring of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
  • Microsoft System Center Management Pack (CTP2) for SQL Server 2014 (6.7.0.0) This Management Pack enables the monitoring of the following features: SQL Server 2014 Database Engines (supported editions: Enterprise, Business Intelligence, Standard, Express), SQL Server 2014 Databases (including file groups, data files and transaction log files), SQL Server 2014 Agent, SQL Server 2014 Always On Availability Groups, SQL Server 2014 Failover Clusters, SQL Server 2014 Mirroring, SQL Server 2014 In-Memory OLTP, SQL Server 2014 Managed Backup to Windows Azure, SQL Server 2014 Integration Services.
  • Microsoft System Center Management Pack for SQL Server 2016 RC3 (6.7.0.0) This Management Pack enables the monitoring of the following features: SQL Server 2016 Database Engines (supported editions: Enterprise, Business Intelligence, Standard, Express), SQL Server 2016 Databases (including file groups, data files and transaction log files), SQL Server 2016 Agent, SQL Server 2016 Always On Availability Groups, SQL Server 2016 Failover Clusters, SQL Server 2016 Mirroring, SQL Server 2016 In-Memory OLTP, SQL Server 2016 Managed Backup to Windows Azure, SQL Server 2016 Integration Services.

New SQL Server Dashboards MP Features and Fixes in CTP 2

  • Added a feature to support Virtual Groups (groups defined by classes, not by real group instance). This will help users with partial access to use our predefined dashboards.
  • Added a feature to Bulk Add tiles from the class definition.
  • Added a feature to ignore some states while calculating the worst state for the Datacenter View State Tile; added a feature to set this ignorance up for each group
  • Added a feature to show/hide Instance path in the list on the Instance view
  • Added instance path to the Instance Details
  • Implemented deferred loading of the instance tiles to make the instance view operation faster
  • Implemented a new format for Dashboards configuration providing a smaller size and a single binding
  • Implemented a converter from old to new format providing preservation of user changes
  • Improved error reporting
  • Improved performance of initial load process
  • Improved data sources performance
  • Improved performance of instance selection (made it asynchronous)
  • Improved performance of Datacenter and Instance View Tiles, loading and loaded animations
  • Fixed animation issues and minor visual glitches (positioning, size of elements, fonts, main loading animation)
  • Updated Summary dashboard
  • “Known issues and Troubleshooting” section of the guide is updated

New SQL Server 2005-2012 MP Features and Fixes in CTP 2

  • Fixed Always On Database replica discovery incorrect behavior; fixed Always On policies discovery and monitoring
  • Fixed Database policies discovery and monitoring
  • Fixed and optimized CPU Usage monitoring scripts (the issue appeared when only one core was assigned)
  • Added support for more than 32 processors count in CPU Usage monitoring.
  • SQLPS module is now used for the tasks instead of deprecated SQLPS.EXE
  • Implemented FILESTREAM filegroup monitoring
  • Multiple Ports are now supported in SQL Server TCP/IP parameters
  • Fixed error occurring when no port is specified in SQL Server TCP/IP parameters
  • Fixed filegroup read-only state discovery
  • Fixed RunAs profiles mapping for some workflows
  • Implemented support for TLS 1.2 in connection logic
  • Implemented support for different client drivers in connection logic
  • Updated connection logic error logging
  • Added RunAs profiles for mirroring monitors, fixed mirroring discovery issues
  • Fixed issue: CPU usage monitor ignored SQL server limitations on CPU core count
  • Fixed display strings and Knowledge Base articles
  • Fixed error reporting in the scripts

New SQL Server 2014 MP Features and Fixes in CTP 2

  • Fixed Smart Admin policies monitoring
  • Fixed Always On Database replica discovery incorrect behavior; fixed Always On policies discovery and monitoring
  • Fixed Database policies discovery and monitoring
  • Fixed and optimized CPU Usage monitoring scripts (the issue appeared when only one core was assigned)
  • Added support for more than 32 processors count in CPU Usage monitoring.
  • SQLPS module is now used for the tasks instead of deprecated SQLPS.EXE
  • Implemented FILESTREAM filegroup monitoring
  • FILESTREAM is now supported on the summary dashboard
  • Multiple Ports are now supported in SQL Server TCP/IP parameters
  • Fixed error occurring when no port is specified in SQL Server TCP/IP parameters
  • Fixed filegroup read-only state discovery
  • Fixed RunAs profiles mapping for some workflows
  • Changed implementation of Memory-Optimized Data free space calculation
  • Added Memory-Optimized Data Stale Checkpoint File Pairs Ratio Monitor
  • Implemented support for TLS 1.2 in connection logic
  • Implemented support for different client drivers in connection logic
  • Updated connection logic error logging
  • Updated SMO usage in Always On workflows to support the new connection logic
  • Fixed issue: CPU usage monitor ignored SQL server limitations on CPU core count
  • Fixed display strings and Knowledge Base articles
  • Fixed error reporting in the scripts

New SQL Server 2016 MP Features and Fixes in CTP 2

  • Fixed Smart Admin policies monitoring
  • Fixed Always On Database replica discovery incorrect behavior; fixed Always On policies discovery and monitoring
  • Fixed Database policies discovery and monitoring
  • Fixed and optimized CPU Usage monitoring scripts (the issue appeared when only one core was assigned)
  • Added support for more than 32 processors count in CPU Usage monitoring.
  • SQLPS module is now used for the tasks instead of deprecated SQLPS.EXE
  • Implemented FILESTREAM filegroup monitoring
  • FILESTREAM is now supported on the summary dashboard
  • Multiple Ports are now supported in SQL Server TCP/IP parameters
  • Fixed error occurring when no port is specified in SQL Server TCP/IP parameters
  • Fix filegroup read-only state discovery
  • Fixed RunAs profiles mapping for some workflows
  • Added support for new SQL Server 2016 Memory-Optimized Data implementation
  • Implemented support for TLS 1.2 in connection logic
  • Implemented support for different client drivers in connection logic
  • Updated connection logic error logging
  • Updated Availability Group Automatic Failover monitor
  • Added rules to collect new Always On performance counters
  • Updated SMO usage in Always On workflows to support the new connection logic
  • Upgraded the used PowerShell version to 3+, since SQL Server 2016 uses .Net 4 Runtime
  • Fixed issue: CPU usage monitor ignored SQL server limitations on CPU core count
  • Fixed display strings and Knowledge Base articles
  • Fixed error reporting in the scripts

We are looking forward to hearing your feedback.

Comments

  • Anonymous
    May 25, 2016
    The comment has been removed
    • Anonymous
      May 25, 2016
      We'll look into this quickly and get back to you here. Thank you.
      • Anonymous
        June 28, 2016
        Hi,Same issue in our SQL Server 2014 environment with 6.7.1.0 (CTP 2.1). A lot of bugs in combination with Always On has already been fixed in this CTP, but this bug is confusing, because it doesn't appear on every replica. Did you already fix this?Do you know a timeline for a new CTP or RTM? Thanks!
        • Anonymous
          June 30, 2016
          We released the RTM version 6.7.2.0 this week. It should be fixed there. Could you try and let us know if you still see the issue? Thanks.
    • Anonymous
      May 26, 2016
      Please email us at sqlmpsfeedback@microsoft.com with additional details on your case:1. How often do such events appear in the log?2. How was your AG configured (number of replicas, secondaries are readable or not)?3. Was there an outage of Windows Cluster service or a system reboot?4. Was a failover triggered before these events became appearing in the log?Also, if it's possible, attach Application, System, and Operations Manager logs exported from agents where replicas of AG are installed.
      • Anonymous
        May 31, 2016
        I just sent the information to the provided email address.
  • Anonymous
    June 02, 2016
    Hi,Can not import on SCOM 2007 R2 ? Not compatible ?
    • Anonymous
      June 03, 2016
      It depends on which MP you are trying to import.Any of the SQL MPs can be imported on SCOM 2007 R2 and SCOM 2012 RTM but without dashboards. Requirements for dashboards is SCOM 2012 SP1 and newer.Replication MPs can be imported to SCOM 2012 starting with RTM, without dashboards as well.Please let us know if you see these configurations not working. Thanks.
      • Anonymous
        June 06, 2016
        I'm trying to import Microsoft.SQLServer.Generic.Presentation version 6.7.0.0Microsoft.SQLServer.Library version 6.7.0.0both failed
        • Anonymous
          June 07, 2016
          Those should have worked. We cannot repro this in our test environment. Could you share the error messages you are getting? Either here or email us at sqlmpsfeedback@microsoft.com. Thank you.
  • Anonymous
    June 13, 2016
    My client does not want to install a management pack that isn't a general release.....any idea when the 6.7.0.0 will reach GA ?
    • Anonymous
      June 13, 2016
      We are targeting end of June. Thanks.
  • Anonymous
    June 15, 2016
    The comment has been removed
    • Anonymous
      June 15, 2016
      Probably, you see these alerts for 32-bit SQL Server instances installed on 64-bit Windows. SQL MPs do not support such configuration, only 32 on 32 or 64 on 64. After releasing 6.7.1.0, we disabled performance rules and some monitors for 32 on 64 configuration to avoid the appearance of these alerts. You can email us at sqlmpsfeedback@microsoft.com and request a version with disabled workflows to try it before we publish GA.If you see these alerts for 64 on 64 instances, please contact us at sqlmpsfeedback@microsoft.com and we'll look more deeply into your problem.
      • Anonymous
        June 16, 2016
        Thanks, Alex. It seems you are right, it is 32 on 64. I wrote a request to the specified email address.
  • Anonymous
    September 06, 2016
    Will vbs script rewritten on powershell in future ?
    • Anonymous
      September 08, 2016
      We plan to move to a newer scripting language but we are not close enough to commit to a technology or date yet. Was there a particular concern or issue you have? Thanks.