The script is available for download from https://gallery.technet.microsoft.com//How-to-get-SQL-Server-8fe8ab2d. You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.
This PowerShell script is used to get SQL Server buffer pool usage. It will demonstrate how to get the following information:
System memory usage
Memory usage of the SQL Server process
Total buffer usage of databases
The count of pages loaded for each object in the current database
As some people want to know what the memory resource is used for, we provide this script to show which objects are consuming the memory or buffer pool.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery