#Provide SQLServerName
$SQLServer ="localhost"
#Provide Database Name
$DatabaseName ="master"
#Prompt for user credentials
$credential = Get-Credential

$Query = "
-- Memory used by each database
SELECT
DB_NAME(database_id) AS DB_Name,
COUNT (1) * 8 / 1024 AS MB_Used
FROM sys.dm_os_buffer_descriptors
GROUP BY database_id
ORDER BY COUNT (*) * 8 / 1024 DESC
GO
"

# Start the process here
do {

invoke-sqlcmd -ServerInstance $SQLServer -Database $DatabaseName -Credential $credential -Query $Query | Format-Table

Sleep 1; Clear

}

while ($true)