sp_Blitz "Too Much Free Memory" on seldom-used SSRS instance sp_Blitz (20160715) is reporting "Too Much Free Memory" on a seldom-used 2012 SP2 CU12 test instance (Developer Edition) that only contains the databases created and used by SSRS. The Details are: 


  0GB of free memory inside SQL Server's buffer pool, which is 0GB. You
  would think lots of free memory would be good, but check out the URL
  for more information.


I modified the query to return the raw values and got Free = 587,896 and Total = 1,052,256. My altered query:

SELECT Free = cFree.cntr_value, Total = cTotal.cntr_value
FROM sys.dm_os_performance_counters cFree
INNER JOIN sys.dm_os_performance_counters cTotal ON cTotal.object_name LIKE N'%Memory Manager%'
    AND cTotal.counter_name = N'Total Server Memory (KB)                                                                                                        '
WHERE cFree.object_name LIKE N'%Memory Manager%'
    AND cFree.counter_name = N'Free Memory (KB)                                                                                                                '
    AND CAST(cTotal.cntr_value AS BIGINT) * .3 &lt;= CAST(cFree.cntr_value AS BIGINT)
     AND CAST(SERVERPROPERTY('edition') AS VARCHAR(100)) NOT LIKE '%Standard%'


dbo.sp_BlitzCache (@BringThePain = 1) displays 316 rows, all apparently built-in SSRS housekeeping statements. Is it more likely that:


I have a problem as described at
https://www.brentozar.com/blitz/too-much-free-memory/, or 
The WHERE clause of the sp_Blitz query needs tweaking to avoid a false positive in this circumstance
I logged a bug for it over on the SQL Server First Responder Kit repository on Github. You can check it for status and also add to it as needed.