SteveSext
asked on
SQL server 2006 Memory Performance
I have a server running windows Server 2008 64 bit with SQL Server 2008 64 bit r2 installed. There is 32 GB RAM.
I am noticing 100% memory use by SQL server. I have read plenty of articles stating that SQL server will use as much memory as is available. My question is surely MS have released a patch or process to control this usage?
If I restart the SQL service, meory usage drops and it grows again over a few hours.
Has anyone seen similar behaviour and if so, what can you recommend to manage this usage to keep it performing well?
Thanks
I am noticing 100% memory use by SQL server. I have read plenty of articles stating that SQL server will use as much memory as is available. My question is surely MS have released a patch or process to control this usage?
If I restart the SQL service, meory usage drops and it grows again over a few hours.
Has anyone seen similar behaviour and if so, what can you recommend to manage this usage to keep it performing well?
Thanks
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.