SQL Procedure Cache getting wiped out every 60 seconds
&quot;A significant part of sql server process memory has been paged out...&quot;

I would start with above message. This message means SQL Server working set memory is paging out process to disk. A widely used workaround is, and since you have SQL Server running on Azure VM, to provide SQL Server service account Locked pages in memory (LPIM) privilege. Please refer to this MS support article . To assign LPIM
To assign the Lock pages in memory user right, follow these steps:


Click Start, click Run, type gpedit.msc, and then click OK.

Note The Group Policy dialog box appears.

Expand Computer Configuration, and then expand Windows Settings.

Expand Security Settings, and then expand Local Policies.

Click User Rights Assignment, and then double-click Lock pages in memory.

In the Local Security Policy Settingdialog box, click Add User or Group.

In the Select Users or Groups dialog box, add the account that has permission to run the Sqlservr.exe file, and then click OK.

Close the Group Policy dialog box.
9.Restart the SQL Server service.