Resolving Memory Issues in SQL Server

Posted by on April 7, 2015 Leave a comment (0) Go to comments

get more RAM
run sql server on a dedicated machine with nothing else running on it
dont leave RDP sessions running constantly on SQL Server
DONT start SSMS on the server locally
try to use 64bit version
lock pages in memory access should be there for the service account
Monitor SQL Server:Buffer Manager – Page Life Expectancy (higher is better)
Monitor SQL Server:Buffer Manager – Buffer Cache Hit Ratio(higher is better)

Uncategorized

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>