Skip to content

Commit a61ed79

Browse files
authored
Merge pull request #6437 from mzaman1/apsau7
changed moniker and known issues
2 parents a0608b6 + ace2130 commit a61ed79

1 file changed

Lines changed: 6 additions & 12 deletions

File tree

docs/analytics-platform-system/whats-new-analytics-platform-system.md

Lines changed: 6 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -13,10 +13,10 @@ ms.reviewer: "martinle"
1313
# What's new in Analytics Platform System, a scale-out MPP data warehouse
1414
See what’s new in the latest Appliance Updates for Microsoft® Analytics Platform System (APS). APS is a scale-out on-premises appliance that hosts MPP SQL Server Parallel Data Warehouse.
1515

16-
::: moniker range="= aps-pdw-2016-au7 || = sqlallproducts-allversions"
16+
::: moniker range=">= aps-pdw-2016-au7 || = sqlallproducts-allversions"
1717

18-
## APS 2016-AU7
19-
APS 2016-AU6 is a prerequisite to upgrade to AU7. The following are new in APS AU7:
18+
## APS AU7
19+
APS 2016 is a prerequisite to upgrade to AU7. The following are new in APS AU7:
2020

2121
### Auto-create and auto-update statistics
2222
APS AU7 creates and updates statistics automatically, by default. To update statistics settings, administrators can use a new feature switch menu item in the [Configuration Manager](appliance-configuration.md#CMTasks). The [feature switch](appliance-feature-switch.md) controls the auto-create, auto-update, and asynchronous update behavior of statistics. You can also update statistics settings with the [ALTER DATABASE (Parallel Data Warehouse)](/sql/t-sql/statements/alter-database-parallel-data-warehouse) statement.
@@ -32,18 +32,12 @@ APS AU7 introduces Feature Switch in [Configuration Manager](launch-the-configur
3232
### Known Issues
3333
With APS AU7 software, an Intel BIOS update is provided which fixes a problem described as *speculative execution side-channel attacks*. The attacks aim to exploit what are called *Spectre and Meltdown vulnerabilities*. Although packaged together with APS, the BIOS update is installed manually, and not as part of the APS AU7 software install.
3434

35-
Microsoft advises all customers to install the BIOS updated. Microsoft has measured the effect of the following configurations on various SQL workloads in various environments. The measurements found significant degradation on some workloads:
36-
37-
- Kernel Virtual Address Shadowing (KVAS)
38-
- Kernel Page Table Indirection (KPTI)
39-
- Indirect Branch Prediction mitigation (IBP)
40-
41-
Based on the results, the recommendation is that you test the performance effect of enabling BIOS update before you deploy them in a production environment. If the performance effect of enabling these features is too high for your application, consider whether a better mitigation is to isolate your APS Appliance from any untrusted code that is running. See SQL Server guidance [here](https://support.microsoft.com/en-us/help/4073225/guidance-protect-sql-server-against-spectre-meltdown).
35+
Microsoft advises all customers to install the BIOS updated. Microsoft has measured the effect of Kernel Virtual Address Shadowing (KVAS), Kernel Page Table Indirection (KPTI) and Indirect Branch Prediction mitigation (IBP) on various SQL workloads in various environments. The measurements found significant degradation on some workloads. Based on the results, the recommendation is that you test the performance effect of enabling BIOS update before you deploy them in a production environment. See SQL Server guidance [here](https://support.microsoft.com/en-us/help/4073225/guidance-protect-sql-server-against-spectre-meltdown).
4236

4337
::: moniker-end
44-
::: moniker range="= aps-pdw-2016 || = sqlallproducts-allversions"
38+
::: moniker range=">= aps-pdw-2016 || = sqlallproducts-allversions"
4539

46-
## APS 2016-AU6
40+
## APS 2016
4741
This section described the new features for APS 2016-AU6.
4842

4943
### SQL Server 2016

0 commit comments

Comments
 (0)