Contrary to common perception, today’s Microsoft SQL Server is no longer an off the shelf RDBMS system that you install and run with its default settings. With version 2019 you get one of the most sophisticated and technologically advanced systems on the market comparable to the likes of Oracle.
To help the average user, we have outlined 4 areas to look at with a brief summary and we will be following up with additional articles on the specifics of each.
InstallationWindows Performance MonitorIn-Memory OLTPTempDB0