Data warehouse performance tuning - 5 point plan

PowerShell
, , , ,
1

We are planning to do our Data warehouse performance tuning - 5 Point Plan, when i was refer the below article it is mentioned that SQL 2012 and System Center 2012 R2 Database Tweaks in the 2nd Point Plan i.e. Configuration.

Here i have couple of questions on the same point:

  1. In our environment we have SCOM 1801 and MS SQL Server 2016 so will this article applicable to SCOM 1801 and MS SQL Server 2016
  2. If not could you please share the application article for our environment
Thanks.
2

Have you watched the squaredup youtube video on tuning the data warehouse? There was a lot of good information in it.

 

https://www.youtube.com/watch?v=NuYm7e5QZfE

3

The SQL Schema hasn’t changed much between 2012/2016/1801. Most of the SQL items don’t relate to the SQL schema either, more settings to be enabled/disabled, and recommendations for the general configuration.

Also worth checking out Kevin Holmans blog:

https://blogs.technet.microsoft.com/kevinholman/2017/03/08/recommended-registry-tweaks-for-scom-2016-management-servers/