Waits can be viewed at an aggregate level on the server, and on an individual basis for executing queries. Duration and worker time and IO are tracked for query executions....

Guessing here, but I think you want a FULL OUTER JOIN on Last Name, First Name and Product Name (QualityType is a possibility too I suppose). You can filter after...

We are still just flopping and twitching here on the forum, and are no closer to a resolution. Some likely final comments:

1) shrinking tempdb cannot possibly help improve...

That is the SQL Server build number. You are 14 months behind as CU7 for SP3, build 6579, was released Jan 17, 2017. It is absolutely possible that you have memory...

There's a lot more to dbcc memorystatus than what you posted. What did your review of the documentation online reveal? 

https://support.microsoft.com/en-us/help/907877/how-to-use-the-dbcc-memorystatus-command-to-monitor-memory-usage-on-sql-server-2005

Also review this:

I will add that doing your activities one-at-a-time gives you control over error handling too, which other mechanisms that may put all of your code in one statement may not...

1) You posted this on SQL 2012 forum, but I thought Free Pages went away in that version

https://blogs.msdn.microsoft.com/vsanil/2012/11/21/did-some-performance-counters-like-free-pages-disappear-in-sql-2012/

2) How is your IO amount and...