Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sp_Blitz is reporting "Too Much Free Memory" on a seldom-used instance #412

Closed
TaraKizer opened this issue Aug 5, 2016 · 1 comment
Closed
Assignees
Labels
Milestone

Comments

@TaraKizer
Copy link
Contributor

Mark Freeman reported this issue at StackExchange: http://dba.stackexchange.com/questions/146044/sp-blitz-too-much-free-memory-on-seldom-used-ssrs-instance

His test instance is seldomly used and reporting "Too Much Free Memory".

"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."

@BrentOzar BrentOzar self-assigned this Aug 6, 2016
@BrentOzar BrentOzar added this to the 2016-08 milestone Aug 6, 2016
@BrentOzar
Copy link
Member

Great catch. Added the below to the WHERE clause so that we're only alerting on servers with at least 4000MB of memory, because I can totally see this happening on user desktops too and it not being a big deal:

AND CAST(cTotal.cntr_value AS BIGINT) > 4000

BrentOzar added a commit that referenced this issue Aug 6, 2016
Closes #412. Added this to the WHERE clause on the free RAM check:

AND CAST(cTotal.cntr_value AS BIGINT) > 4000
BrentOzar added a commit that referenced this issue Aug 6, 2016
#412 sp_Blitz reporting too much free memory on small boxes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants