Tag Archives: Preview

Released: Public Preview for SQL Server Management Packs Update (7.0.5.0) and SSRS Management Pack Update (7.0.6.0)

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 SQL Server 2008-2012 MP Features and Fixes

  • Updated the “Max worker thread count” data source of the corresponding monitor and performance rule
  • Fixed issue: the “Transaction Log Free Space (%)” monitor does not work
  • Fixed issue: in some environments, DB Space workflows fail when a secondary database is non-readable

New SQL Server 2014-2016 MP Features and Fixes

  • Updated alert severity in some monitors
  • Updated the display strings
  • Updated the “Max worker thread count” data source of the corresponding monitor and performance rule
  • Fixed issue: the “Transaction Log Free Space (%)” monitor does not work

New SQL Server 2017+ MP Features and Fixes

  • Implemented an ability to monitor SQL Server Cluster instances locally; formerly, it was possible only in Agentless and Mixed modes
  • Added the SSIS monitoring
  • Added the “Exclude List” property in DB Engine Discovery in order to filter instances, which are not subject to monitoring
  • Added the “Exclude List” property in DB Discovery in order to filter databases, which are not subject to monitoring
  • Implemented a feature: both “Exclude List” properties support usage of the asterisk character to make the filter more flexible. E.g. “*temp” is used to exclude instances/databases ending with “temp” and having anything in the beginning.
  • Added the “Computers” view
  • Added the “ClusterName” property to the AG class and updated AG alerts in order to display the property within
  • Updated the “SP Compliance” monitor in order to support the Modern Servicing Model for SQL Server: the monitor will check build number instead of Service Pack number
  • Updated the “SPN Status” monitor so that it requires only a single SPN record when only TCP/IP is enabled and the instance is the default one
  • Updated the “Database Backup Status” monitor: it is disabled by default now
  • Updated the DB Space monitors so that their alert descriptions include the actual value of space available
  • Updated the “Configuration Security” section in the guide
  • Fixed issue: the “Database Health Policy” monitor ignores the “Critical” state (on Windows only)
  • Fixed issue: the “Alert severity” property of the “DB File Free Space Left” monitor has incorrect Default Value
  • Fixed issue: the “DB Filegroup Fx Container” rollup monitor has an alert parameter with a wrong value within
  • Fixed issue: “Resource Pool Memory consumption” monitor may not change its state to “Critical” for the “default” resource pool
  • Fixed issue: “Number of Samples” parameter of “Resource Pool Memory consumption” alert displays incorrect data
  • Fixed issue: missed image resources in the SQL Server 2017+ Core Library

New SSRS 2008-2016 MP Features and Fixes

  • Added support for cases when a connection string of the SSRS instance to the SSRS Database is not in the “MachineName\InstanceName” format; e.g. “<IP Address>,<Port Number>” or “(local)”, etc. Such connection strings are fully supported for default SQL Server instances hosting the SSRS Database. If the instance is named, workflows targeted at the SSRS Instance object work properly, but those targeted at the Deployment object cannot work, as there is no possibility to learn the FQDN of the server.
  • Updated the Deployment Seed discovery so that it does not check if the SQL Server instance hosting the SSRS Database is running

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com.

Let’s block ads! (Why?)

SQL Server Release Services

Microsoft launches Project Brainwave for deep learning acceleration in preview

Microsoft today announced that Project Brainwave, its system for running AI models with specialized chips, is now available in preview on Azure. Brainwave allows developers to deploy machine learning models onto programmable silicon and achieve high performance beyond what they’d be able to get from a CPU or GPU. Microsoft claims Project Brainwave makes Azure the fastest cloud to run real-time AI today.

Brainwave uses specialized field programmable gate array (FPGA) chips to achieve its speed and low latency, and Brainwave on Azure will use Intel Stratix 10 chips and be able to support ResNet50-based neural networks.

Microsoft first revealed its use of Brainwave for serving AI models last summer, and in March said it’s being used to make AI that powers Bing search results 10 times faster.

The news was announced onstage at Build, the Microsoft annual developer conference being held May 7-9 at the Washington State Convention Center in Seattle, Washington.

Also announced today were updates to Azure Bot Service and IoT Edge, a Speech Devices SDK, a $ 25 million initiative to support the creation of AI for people with disabilities, and Amazon joined Microsoft onstage for a demonstration of how Cortana and Alexa will work together.

 Microsoft launches Project Brainwave for deep learning acceleration in preview

Let’s block ads! (Why?)

Big Data – VentureBeat

Released: Public Preview for SQL Server Management Packs Update (7.0.3.0)

We are getting ready to update the SQL Server 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

Included in the download are Microsoft System Center Management Packs for SQL Server 2008/2008 R2/2012/2014/2016 (7.0.3.0).

Please read if you have more than 1500 database files

When a SQL Server instance has about 1500 or more database files, the Data Files Discovery generates an output, which exceeds the SCOM Agent 4 MB threshold, and then the discovery fails. We added a new “Discover DB Group Seed” discovery to make the MP monitor such instances smoothly. If the data files in your environment cannot be discovered due to the 4 MB threshold, just enable the new discovery. Note that you should not enable it unless you face the problem described above.

New SQL Server 2008-2012 MP Features and Fixes

  • Fixed issue: Agent tasks do not have any SQL MP Run as Profile mapped
  • Implemented caching of data received from WMI to reduce the number of requests to WMI
  • Changed ps1 data source scripts to avoid the “Pipe is being closed” error
  • Disabled Latency Disk Read/Write performance rules by default
  • Added the actual value of available disk space in DB Space monitoring alerts
  • Updated some of the display strings
  • Increased SQL Command timeout in the data source scripts up to 60 seconds (previously it was 30 seconds)

New SQL Server 2014-2016 MP Features and Fixes

  • Added a new discovery for dealing with cases when an SQL Server instance has a vast of database files (near 1500 and more); it is disabled by default
  • Implemented caching of data received from WMI to reduce the number of requests to WMI
  • Improved the output of discoveries of Database Filegroups and Files so they do not contain unnecessary data
  • Changed ps1 data source scripts to avoid the “Pipe is being closed” error
  • Disabled Latency Disk Read/Write performance rules by default
  • Added the actual value of available disk space in DB Space monitoring alerts
  • Updated some of the display strings
  • Increased SQL Command timeout in the data source scripts up to 60 seconds (previously it was 30 seconds)

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com. 

Let’s block ads! (Why?)

SQL Server Release Services

Public Preview: Azure SQL Database – Managed Instance Management Pack

We are happy to announce the public preview release of System Center Management Pack for Azure SQL Database – Managed Instance! This is a brand new MP to monitor the new Azure SQL Database – Managed Instance. We are looking forward to getting your feedback on the preview. Please email us at sqlmpsfeedback@microsoft.com.

Download available:

Microsoft System Center Management Pack (Community Technology Preview) for Microsoft Azure SQL Database – Managed Instance

The Management Pack (CTP) for Microsoft Azure SQL Database – Managed Instance enables you to monitor the availability and performance of your Managed Instances.

Note: This Management Pack is neither part of Microsoft System Center Management Pack for Microsoft Azure nor Microsoft System Center Management Pack for Microsoft Azure SQL Database. This management pack provides monitoring, which is quite similar to monitoring of on-premises SQL Server 2017 provided by the Microsoft System Center Management Pack for SQL Server 2017+.

Note: This CTP release covers only a subset of monitors and rules. It does not offer low-privilege monitoring configuration. We will work towards the full functionality as we release new CTPs.

Feature Summary

After configuration, the Microsoft Azure SQL Database – Managed Instance Management Pack (Community Technology Preview) offers the following functional capabilities:

  • User-friendly wizard to discover Managed Instances
  • Support for Multiple Managed Instances
  • Monitoring of Managed Instance health and performance
    • Managed Instance availability and performance

      • Managed Instance Health Status
      • Managed Instance Securables Configuration
      • CPU Consumption
      • Average Wait Time
      • SQL Re-Compilation
      • User Connections
      • HTTP Storage Performance
      • Memory-Optimized Data Transactions Performance
      • and others
    • Database availability and performance
      • Database Status
      • Database Configuration
      • Database Performance
      • Memory-Optimized Data Filegroups Configuration
      • Memory-Optimized Data Filegroups Performance
      • Resource Pool Performance

Managed Instance will show up as first level folder under Monitoring on your SCOM console.

Let’s block ads! (Why?)

SQL Server Release Services

Released: Public Preview for SQL Server Management Packs Update (6.7.34.0)

We are getting ready to update the SQL Server 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

Included in the download are Microsoft System Center Management Packs for SQL Server 2008/2008 R2/2012/2014/2016 (6.7.34.0).

New SQL Server 2008-2012 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks

New SQL Server 2014 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks

 New SQL Server 2016 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Enabled Memory-Optimized workflows for all editions of SQL Server 2016 by default, so far as all editions now support Memory-Optimized Data since SP1
  • Disabled the alerting rule for event #18456 by default
  • Optimized ProbeAction for User Resource Pool Memory workflows
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks
  • Fixed issue: “XTP Configuration” monitor is in healthy state when XTP filegroup container and the transaction log are placed on different volumes of a physical disk
  • Fixed issue: Incorrect publishers’ names for SSIS EventCollection rules (SQL2016)
  • Fixed issue: GetSQL2016DBEngineWinServState.js crashes when getting neither “true” nor “false” as the second parameter (CheckStartupType)

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com.

Let’s block ads! (Why?)

SQL Server Release Services

Released: Public Preview for SQL Server 2017+ and Replication Management Pack (RC)

We are happy to announce SQL Server 2017+ Management Pack Release Candidate with new features is ready (6.7.65.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).

NEW: Version Agnostic SQL Server MPs

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 this issue. This will be valid going forward. The new MP is named SQL Server 2017+. The ‘+’ in the name indicates that it will be used to monitor SQL Server 2017 and the releases that come after that. Current in-market MPs (2008 through 2016) will not be changed and the 2017+ MP cannot be used to monitor older releases. We are making this change for SQL Server and Replication MPs. It would be great to get your feedback on this public preview before we reach GA.

Please download the public preview bits at:

Microsoft System Center Management Pack (Release Candidate 1) for SQL Server 2017+

Microsoft System Center Management Pack (Release Candidate 1) for SQL Server 2017+ Replication

New Features and Fixes for SQL Server 2017+ Windows and Linux MP (6.7.65.0)

  • The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
  • Reduced the number of files in the management pack
  • Removed dependency on SQL Server Dashboards management pack
  • Introduced a number of fixes and improvements to functionality, performance, and display strings

New Features and Fixes for SQL Server 2017+ Replication Windows MP (6.7.65.0)

  • The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
  • Reduced the number of files in the management pack
  • Introduced a number of fixes and improvements to functionality, performance, and display strings
Feature/Workflow
CTP1 (6.7.18.0)
CTP2 (6.7.40.0)
CTP3 (6.7.55.0)
CTP4 (6.7.60.0)
RC (6.7.65.0)
Core objects
DB Engine Discovery W/L W/L W/L W/L W/L
Local DB Engine Discovery (windows only feature) W W W W
SQL Cluster instances W W W W W
DB Discovery W/L W/L W/L W/L W/L
DB Filegroup Discovery W/L W/L W/L W/L W/L
DB File Discovery W/L W/L W/L W/L W/L
DB Log file Discovery W/L W/L W/L W/L W/L
DB Policy Discovery W/L W/L W/L W/L
Filestream Filegroup Discovery W W W W
Memory-Optimized Data Filegroup Discovery W/L W/L W/L W/L
Memory-Optimized Data Filegroup Containers Discovery W/L W/L W/L W/L
DB Engine Resource pool Discovery W/L W/L W/L
SQL Agent Discovery W/L W/L W/L
Always On Discovery W W/L W/L
Features
Agentless Monitoring W/L W/L W/L W/L W/L
Mixed monitoring (windows only feature) W W W W W
Agent Monitoring (windows only feature) W W W W W
SQL Credentials W/L W/L W/L W/L W/L
AD Credentials W W W W/L W/L
In-memory OLTP support W/L W/L W/L W/L
SQL Server Express support W W W W/L W/L
MSSQL LogReader module W/L W/L W/L W/L
Support long names (windows only feature) W W W W W
Wizard multithreading W/L W/L W/L W/L
Tasks Execution W/L W/L W/L
Docker Support L L L
Monitoring Scenarios
DB Engine Health Status Monitoring W/L W/L W/L W/L W/L
DB Engine Performance Monitoring W/L W/L W/L W/L W/L
DB Engine Service Pack Compliance Monitoring W/L W/L W/L W/L
DB Configuration Monitoring W/L W/L W/L W/L W/L
DB Memory-Optimized Data Filegroup Performance Monitoring W W W/L W/L
CPU Monitoring and performance metrics W W W W/L
Log Shipping monitoring W W W W/L
WMI Health Monitoring W/NA W/NA W/NA W/NA
Event Base monitoring (400+ Alert rules) W/L W/L W/L W/L
DB Space Monitoring and performance metrics collection W W W W/L W/L
DB Space Monitoring and performance metrics collection for Filestream objects W W W W
DB Space Monitoring and performance metrics collection for Hekaton objects W W W W/L
SQL Full-text Filter Daemon Launcher Service Monitoring W/L W/L W/L W/L
SQL Agent Monitoring W/L W/L W/L
Always On Monitoring W W/L W/L

Legend

Completed

W – Supported on Windows

L – Supported on Linux

W/L – Supported on Windows and Linux

W/NA – Supported on Windows but no applicable to Linux

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack.

We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com).

Let’s block ads! (Why?)

SQL Server Release Services

Power BI Report Server August 2017 Preview now available

Greetings from SQLSaturday in Vancouver, Canada!

Today, we’re excited to release a preview of the next version of Power BI Report Server. This preview release contains some great new self-service BI capabilities, including support for data sources other than SQL Server Analysis Services and viewing and interacting with Excel Workbooks.

Download Power BI Report Server August 2017 Preview!

Publish Power BI reports with imported data

The June 2017 version of Power BI Report Server gave users the ability to create and publish Power BI reports on-premises by connecting to SQL Server Analysis Services data sources. Since then, we’ve heard repeatedly from customers about their need to publish Power BI reports created against other data sources and are pleased to give you an early preview of our progress.

With this August 2017 preview, users can create Power BI reports in Power BI Desktop that connect to any data source, and publish their reports to Power BI Report Server. There’s no special configuration required to enable this functionality — simply install and configure the August 2017 preview version of Power BI Report Server on your machine, and you’re ready to go. You can then use the included Power BI Desktop application to connect to your data source(s), create your report, and publish it directly to the report server to share it with your users.

153b0b04 817a 4c1a b293 55a6b5513c72 Power BI Report Server August 2017 Preview now available

Since this is an early preview, there are a few limitations to keep in mind as you try it out. Please note that we plan to support all the below scenarios when we make the GA release available in later in 2017. Some current limitations are:

  • Scheduled data refresh is currently not available for reports using imported data.
  • Direct Query data connections are not currently supported.
  • Scale-out environments for Power BI Report Server are not officially supported using the preview release.
  • Reports must be smaller than 50 MB in size.

View and interact with Excel Workbooks

Excel and Power BI contain a portfolio of tools that is unique in the industry. Together, they enable business analysts to more easily gather, shape, analyze, and visually explore their data. In addition to viewing Power BI reports in the web portal, business users can now do the same with Excel workbooks in the new version of Power BI Report Server, giving them a single location to publish and view their self-service Microsoft BI content.

To do this, customers can take advantage of Office Online Server (OOS), a separate download from Microsoft Office to render Office documents that you can view in your browser. Customers with a Volume Licensing account can download OOS from the Volume License Servicing Center at no cost and will have view-only functionality. We’ve published an easy-to-follow walkthrough of how to add Office Online Server to your Power BI Report Server preview environment. Once configured, users can view and interact with Excel workbooks that:

  • Have no external data source dependencies.
  • Have a live connection to an external SQL Server Analysis Services data source.
  • Have a PowerPivot data model.

4e035ef2 cac7 4ed9 87b0 e3779cd8a22b Power BI Report Server August 2017 Preview now available

To learn about these and other new features in the August preview, including support for the new table and matrix visuals, make sure you read the release notes and supporting documentation we’ve published to the Power BI website. We’re looking forward to hearing your feedback in the comments below or in the Power BI forums.

Try it now

Download Power BI Report Server (Preview)

Check out the preview documentation

Read more about Power BI Report Server at PowerBI.com

Follow @MSPowerBIon Twitter

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Visio custom visual is now in Public Preview and available in the store

We are pleased to announce the Public preview of the Visio custom visual for Power BI.

The Visio custom visual will allow you to visualize data using Microsoft Visio diagrams from within Power BI dashboards and reports. Any Power BI user can add Visio custom visual from the store (get it from the store) to start using this capability right away.

With Visio, you can create illustrative diagrams, such as interconnected workflows and real-world layouts, to pursue operational intelligence. Using Visio and Power BI together, you can illustrate and compare data both as diagrams and as traditional Power BI visuals in one place, driving operational and business intelligence to understand the overall picture.

Note: The Public Preview of Visio custom visual is currently supported in the Power BI service and Power BI Desktop. Support for Power BI Mobile apps will arrive soon.

With this new visual, you can connect to a Visio diagram hosted on SharePoint or OneDrive for Business. The underlying Power BI data is then automatically and intelligently linked to the diagram based on its shape properties, eliminating the need to do this manually. In just a few clicks, Visio diagrams become yet another interactive Power BI visualization that can help you make informed decisions faster.

Try it out now in an embedded report:

Let’s look at this with a fictitious example. Contoso is a large retailer working to improve its inventory management. Using Power BI, the current inventory per store can be represented in a series of visualizations, including a tree-map that shows stock by item (left-side chart in the image below).

52dba25a df26 4acc ae96 039ccf61865a Visio custom visual is now in Public Preview and available in the store

The visuals are perfect for an all-up view of inventory at this store. But what if Contoso needs more nuanced details, such as sales and inventory data for specific clothing racks? What if it needs to understand where each rack is located in the store and how they are positioned relative to one another? Using a Visio diagram of the store’s layout, Contoso can overlay the data in Power BI on Visio’s diagram of the clothing racks. The resulting Power BI dashboard provides an accurate, up-to-date representation of the overall store inventory, while also maintaining the ability to drill into specific items.

eac27730 e76f 4694 a957 3fc07f107c5d Visio custom visual is now in Public Preview and available in the store

The treemap was replaced with individual item racks that have been color-coded and labeled based on the inventory levels from Power BI data. For example, when “Tea Dresses” is clicked in the Visio diagram, you quickly see that sales are very strong, which helps explain why inventory is low. Similarly, when “Suit Coats” is clicked in the Power BI bar chart, you see the item is well below its sales target and inventory is still high. You can also see that the suit coat rack is located in a back corner of the store, making it less accessible to customers. Based on this information, the Contoso team might decide to use more rack space for tea dresses and less for suit coats, or reposition the racks for greater accessibility.

There are endless types of Visio diagrams that can offer more detailed insights with Power BI, including:

  • Flow charts for identifying interdependencies
  • Fishbone diagrams for root-cause analysis
  • Organizational charts for assessing the impact of hierarchies on process decisions and people management

f19326a6 23e6 4560 b04c 42c0a1f9fd89 Visio custom visual is now in Public Preview and available in the store

Visio flowchart illustrating a sample home loan approval process for a bank. Using the Power BI charts, the bank sees that actual ticket response times for performing property risk assessments are higher than expected. In the Visio diagram, that process step is highlighted in red indicating that, because it’s so early in the process, it could affect other steps in the future if the ticket processing issue isn’t resolved soon.

b73ae579 3fa3 4d1d b8f5 8855a2f0675a Visio custom visual is now in Public Preview and available in the store

Fishbone chart showing that poor working conditions — specifically excessive noise and temperature, which are highlighted in red in the Visio diagram — are the root cause of diminished product quality. The diagram relies on the employee ratings of operational categories depicted in the Power BI charts on the right.

9be15e92 d60d 4146 a7bc 5c82fdc92f80 Visio custom visual is now in Public Preview and available in the store

Dashboard showing how certain people and departments, illustrated by the Visio hierarchy diagram in the upper left, affect different organizational processes. In this case, the marketing and sales department is over budget on tele sales and tele call efforts, all of which are highlighted in red.

Known limitations of the Public Preview:

  • To access the Visio diagram from the Visio custom visual, you will need to sign into the host SharePoint with your organizational ID. The visual will prompt you with a sign-in window.
  • To include a Visio visual in a Publish to Web report, you must use an authenticated Visio diagram. Refer to the documentation for details.
  • The Visio visual public preview is not yet supported for Power BI Mobile apps, Power BI Embedded, exporting to PowerPoint, or email subscriptions.

Visio and Power BI are visual tools—each helps you to dissect data in new, meaningful ways. Together, they can uncover even more insights.

Get the Visio custom visual for Power BI from the Office store, or search for it in the integrated store in your Power BI Desktop or Power BI service.

To know more about Visio Power BI custom visual, please refer step-by-step help articles

Please visit our UserVoice site to submit your suggestions for improving Visio-Power BI connectivity. For questions about this and other features, email us at tellvisio@microsoft.com

Lastly, you can follow us on Facebook, YouTube and Twitter for the latest Visio news.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Released: Public Preview for SQL Server 2017 and Replication Management Pack (CTP4)

We are happy to announce SQL Server 2017 Management Pack CTP4 bits with new features are ready (6.7.60.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).

Please download the public preview bits at:

Microsoft System Center Management Pack (Community Technical Preview 4) for SQL Server 2017

Microsoft System Center Management Pack (Community Technology Preview 4) for SQL Server 2017 Replication

New Features and Fixes for SQL Server 2017 Windows and Linux MP (6.7.60.0)

  •   Implemented Always On monitoring on Windows and Linux
  •   Implemented Disk Latency workflows
  •   Added new “Login failed” alerting rule for SQL Server event #18456
  •   Added support for AD Credentials in Agentless Mode on Windows
  •   Added DB Space Forecast report
  •   Fixed issue: different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
  •   Fixed issue: workflows cannot connect to an instance when only Shared Memory protocol is enabled
  •   Introduced a number of improvements to the management pack

New Features and Fixes for SQL Server 2017 Replication Windows MP (6.7.60.0)

  • Added a number of monitors and performance rules to create the same Health model as presented in SQL Server 2008-2016 Replication MPs
  • Improved and refactored the management pack modules
  • Fixed a number of issues
Feature/Workflow CTP1 (6.7.18.0) CTP2 (6.7.40.0) CTP3 (6.7.55.0) CTP4 (6.7.60.0)
Core objects
DB Engine Discovery W/L W/L W/L W/L
Local DB Engine Discovery (windows only feature) W W W
SQL Cluster instances W W W W
DB Discovery W/L W/L W/L W/L
DB Filegroup Discovery W/L W/L W/L W/L
DB File Discovery W/L W/L W/L W/L
DB Log file Discovery W/L W/L W/L W/L
DB Policy Discovery W/L W/L W/L
Filestream Filegroup Discovery W W W
Memory-Optimized Data Filegroup Discovery W/L W/L W/L
Memory-Optimized Data Filegroup Containers Discovery W/L W/L W/L
DB Engine Resource pool Discovery W/L W/L
SQL Agent Discovery W/L W/L
Always On Discovery W W/L
         
Features      
Agentless Monitoring W/L W/L W/L W/L
Mixed monitoring (windows only feature) W W W W
Agent Monitoring (windows only feature) W W W W
SQL Credentials W/L W/L W/L W/L
AD Credentials W W W W
In-memory OLTP support W/L W/L W/L
SQL Server Express support W W W W
MSSQL LogReader module W/L W/L W/L
Support long names (windows only feature) W W W W
Wizard multithreading W/L W/L W/L
Tasks Execution W/L W/L
Docker Support L L
         
Monitoring Scenarios        
DB Engine Health Status Monitoring W/L W/L W/L W/L
DB Engine Performance Monitoring W/L W/L W/L W/L
DB Engine Service Pack Compliance Monitoring W/L W/L W/L
DB Configuration Monitoring W/L W/L W/L W/L
DB Memory-Optimized Data Filegroup Performance Monitoring W W W
CPU Monitoring and performance metrics W W W
Log Shipping monitoring W W W
WMI Health Monitoring W/NA W/NA W/NA
Event Base monitoring (400+ Alert rules) W/L W/L W/L
DB Space Monitoring and performance metrics collection W W W W
DB Space Monitoring and performance metrics collection for Filestream objects W W W
DB Space Monitoring and performance metrics collection for Hekaton objects W W W
SQL Full-text Filter Daemon Launcher Service Monitoring W W W
SQL Agent Monitoring W/L W/L
Always On Monitoring W W/L

Legend

Completed

W – Supported on Windows

L – Supported on Linux

W/L – Supported on Windows and Linux

W/NA – Supported on Windows but no applicable to Linux

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack. Full functionality will be available with SQL Server 2017 GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com).

Let’s block ads! (Why?)

SQL Server Release Services

Released: Public Preview for SQL Server 2017 Management Pack (CTP3)

We are happy to announce SQL Server 2017 Management Pack CTP3 bits with new features are ready (6.7.55.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). On the download page, you will see references to SQL Server vNext instead of 2017. We will update all references to vNext with 2017 in our next CTP, planned for June.

Please download the public preview bits at:

Microsoft System Center Management Pack (Community Technical Preview 3) for SQL Server 2017

New Features and Fixes in CTP3

  • Implemented new workflows:

    • Discoveries for SQL Server Agent and SQL Server Agent Jobs
    • Unit and rollup monitors for SQL Server Agent
    • Performance rules for Resource Pools
    • Alerting rules for SQL Server Agent on Windows
    • Tasks for the Database
    • Tasks for starting/stopping Windows services
    • Monitors and performance rules for Memory-Optimized Tables
    • Always On discoveries
    • “Resource Pool Memory Consumption” monitor
    • “Discover Database Custom User Policy on Windows and Linux” and Discover Database Engine Resource Pools on Windows and Linux” discoveries
    • Console tasks on Windows and Linux
  • Improved SQL queries in the resource pool and database discovery
  • Added discovery of “SQL Server vNext Resource Pool Group on ” to DB Engine discoveries
  • Fixed issue: “Failed to replace parameter while creating the alert for monitor state change” warnings for workflows of Memory-Optimized Tables containers
  • Fixed log reader issues
  • Fixed “SPN Configuration” issue
Feature/Workflow CTP1 (6.7.18.0) CTP2 (6.7.40.0) CTP3 (6.7.55.0)
Core objects
DB Engine Discovery W/L W/L W/L
Local DB Engine Discovery (windows only feature) W W
SQL Cluster instances W W W
DB Discovery W/L W/L W/L
DB Filegroup Discovery W/L W/L W/L
DB File Discovery W/L W/L W/L
DB Log file Discovery W/L W/L W/L
DB Policy Discovery W/L W/L
Filestream Filegroup Discovery W W
Memory-Optimized Data Filegroup Discovery W/L W/L
Memory-Optimized Data Filegroup Containers Discovery W/L W/L
DB Engine Resource pool Discovery W/L
SQL Agent Discovery W/L
Always On Discovery W
Features
Agentless Monitoring W/L W/L W/L
Mixed monitoring (windows only feature) W W W
Agent Monitoring (windows only feature) W W W
SQL Credentials W/L W/L W/L
AD Credentials W W W
In-memory OLTP support W/L W/L
SQL Server Express support W W W
MSSQL LogReader module W/L W/L
Support long names (windows only feature) W W W
Wizard multithreading W/L W/L
Tasks Execution W/L
Docker Support L
Monitoring Scenarios
DB Engine Health Status Monitoring W/L W/L W/L
DB Engine Performance Monitoring W/L W/L W/L
DB Engine Service Pack Compliance Monitoring W/L W/L
DB Configuration Monitoring W/L W/L W/L
DB Memory-Optimized Data Filegroup Performance Monitoring W W
CPU Monitoring and performance metrics W W
Log Shipping monitoring W W
WMI Health Monitoring W/NA W/NA
Event Base monitoring (400+ Alert rules) W/L W/L
DB Space Monitoring and performance metrics collection W W W
DB Space Monitoring and performance metrics collection for Filestream objects W W
DB Space Monitoring and performance metrics collection for Hekaton objects W W
SQL Full-text Filter Daemon Launcher Service Monitoring W W
SQL Agent Monitoring W/L
Always On Monitoring W

Legend

Completed

W – Supported on Windows

L – Supported on Linux

W/L – Supported on Windows and Linux

W/NA – Supported on Windows but no applicable to Linux

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack. Full functionality will be available with SQL Server 2017 GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com)

Let’s block ads! (Why?)

SQL Server Release Services