Pau Lo
asked on
sp blitz memeory dangerously low
I just got copied into a health-check report on a number of corporate SQL servers.
One of the issues it raised was "memory dangerously low" stating the server has 8191 mb of physical memory, but only 233 are available.
Is this a configuration issue - ie is it really saying the server is only configured to use 233 mb - or is this just indicative the server is currently under huge stress?
I dont really understand what the DBA is meant to do about this - if its a setting he can change then fine, but if its because the server is under stress what can he do.
One of the issues it raised was "memory dangerously low" stating the server has 8191 mb of physical memory, but only 233 are available.
Is this a configuration issue - ie is it really saying the server is only configured to use 233 mb - or is this just indicative the server is currently under huge stress?
I dont really understand what the DBA is meant to do about this - if its a setting he can change then fine, but if its because the server is under stress what can he do.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.brentozar.com/blitz/max-memory/