Your current sp_memoryhealthcheck procedure provides a good memory overview, To identify who is using SQL Server memory, which application is responsible, and why a memory-related alert was generated, ...