Finally, two important SQL Server recommended settings have been introduced at the installation setup page. These are the settings that every DBA changes after every single installation. The settings are MaxDOP and Max Memory. MaxDOP: When an instance of SQL Server runs on a computer that has more than one CPU logical core, it detectsContinue reading “SQL Server 2019 introduces recommendations for MAXDOP and Max memory during installation process.”
Category Archives: Install
SQL Server 2012 does not come up after service pack upgrade SP4
I have done countless SQL Server upgrades but rare get issue after the Service Pack upgrade in terms of SQL Server / Database online. Here is one example where I ran into issue and that too the serious one with the master database after SP4 upgrade on SQL 2012. It was one of the productionContinue reading “SQL Server 2012 does not come up after service pack upgrade SP4”
iLearnSQL 