How to increase performance of a SQL 2008 R1 running on Server 2008 R2
We have a virtual Windows Server 2008 R2 box running with 4 CPUs and 8GB of RAM on VMware connected to a NetApp SAN with 15k Disks. Within an hour after boot the RAM is near 7.8GB of usage and the system runs slow. CPU seems to range from 10-30% We have about 15 SQL Database and 200GB of data.
What type of performance recommendation(s) can you recommend? The only thing I saw was to verify clean up jobs are run in the evenings and changed recovery model from FULL to SIMPLE.
What type of performance recommendation(s) can you recommend? The only thing I saw was to verify clean up jobs are run in the evenings and changed recovery model from FULL to SIMPLE.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, this is the setting to change.
ASKER
Max Memory for SQL: You are referring to this setting? http://msdn.microsoft.com/en-us/library/ms178067.aspx
I think you put the nail in our SQL Server. The databases run perfect from our program. The problem is the OS is horribly slow! Therfore I believe the solution above will resolve our problems.