• What else is running on this server apart from the SQL Server? Why such a meagre memory configuration if the server has 512Gb of RAM? Are you RDP'ing on to the box? What would you run in such sessions? Is the server running SSIS, SSRS or SSAS?

    😎