I would suggest trying running the below queries at time when the SQL server is very used. Which should help us in understanding the total memory consumed by SQL Server....
You could run the sql profiler trace to capture the log file details, which will let you know while carrying which activities the log file grows. Once we know the...