Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged ...

A Microsoft data platform MVP on the state of SQL Server today -- how it's evolved in Microsoft's Azure-first word, the best features to emerge in recent years and troubleshooting gotchas.

No SQL service packs as of now. This server supports the accounting department's Solomon IV system and I'm not sure which SQL service pack is supported.