System Center 2016 Service Manager, SQL Server 2016 DWFT 145TB Released

Microsoft announces the availability of System Center 2016 Service Manager, SQL Server 2016 DW Fast Track Reference Architecture, 145TB, and Data Migration Assistant v2.0, DEA.

Share online:

The availability of System Center 2016 Service Manager released today contains a wide array of additions & improvements- its faster, provides better usability, and comes with many new features.

This release offers enhanced performance across all areas of the product, including Work Item creation, Workflow runtime, and Connector sync time.

Here is a quick glimpse of several new features:

  • Data Warehouse cubes now contain new date dimensions which can help in creating rich reports and slice data based on Year, Quarter, Month, Day etc.
  • New HTML based Self Service Portal, which offers many new features with easy to navigate modern UI and multi browser support.
  • sm 2016 blog 2
  • Support for .Net framework 4.5.1, which expands the possibilities for developing solutions on Service Manager platform.
  • Console forms now contain out-of-the-box spell check support, to make life of the help desk analysts a little easier.
  • A new console task – Open Activity in Progress, makes it easier to analyse the currently in progress activities without needing to dig for them inside the Service Request or Change Request forms.
  • Service Manager now supports integration with Lync 2013 and Skype for Business in Microsoft Office suite 2013 and 2016, which helps to contact a user from an Incident form, explains Microsoft.

Service Manager now available in System Center 2016

SQL Server 2016 Data Warehouse Fast Track Reference Architecture, announced today is a reference architectures that certify "a SQL Server 2016 SMP unit can support active data sets of up to 145TB, and maximum user size of 1.2 Petabytes of SQL Data in an all flash system."

These reference architectures provide tested and validated configurations and resources to help customers build the right environment for their data warehouse solutions.

To yield these tangible benefits, just follow the best practices and guidelines:

  • Accelerated data warehouse projects with pre-tested hardware and SQL Server configurations.
  • Reduced hardware and maintenance costs by purchasing a balanced hardware solution and
  • optimizing it for a data warehouse workload.
  • Improved ROI by optimizing software assets.
  • Reduced planning and setup costs by leveraging certified reference architecture configurations.
  • Predictable performance by properly configuring and tuning the system.

Data Migration Assistant (DMA) v2.0 delivers scenarios that reduce the effort to upgrade to latest SQL Server 2016 from legacy SQL Servers by detecting compatibility issues that can impact database functionality after an upgrade.

Back in August, v1.0 of DMA was released under general availability, and since then, according to Microsoft, it has been downloaded "more than 2,000 times world-wide, assessing more than 25,000 (37K Cores) databases with over 1,000 unique users," Microsoft writes.

It recommends performance and reliability improvements for target environment and then migrates the entire SQL Server database, Microsoft added. Furthermore, it also provides seamless assessments and migrations to SQL Azure VM, as well as:

  • DMA assessments discover the breaking changes, behavioral changes and depreciated features that can affect your upgrades.
  • DMA also discovers the new features in the target SQL Server platform that your applications can benefit from after an upgrade.
  • DMA is the only tool providing comprehensive data platform movement capabilities, assisting DBAs with more than just schema and data migrations.

Another tool, Database Experimentation Assistant (DEA) released today is a new A/B testing solution for SQL Server upgrades.

It enables customers to conduct experiments on database workloads across two versions of SQL Server.

Micorosoft nots, customers upgrading from older SQL Server versions (starting 2005 and above) to any new version will be able to use key performance insights, captured using a real world workload to help build confidence about upgrade among database administrators, IT management and application owners by minimizing upgrade risks.

This enables truly risk-free migrations.

Both the tools can be download over here: DMA v2.0, and DEA.