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:
- 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
- If not could you please share the application article for our environment
Have you watched the squaredup youtube video on tuning the data warehouse? There was a lot of good information in it.
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: