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.
LVL 1
First LastAsked:
Who is Participating?
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
If you haven't configured SQL Server to use less memory, it will take all it can get by default.  On my systems with 8GB I often set the max memory setting to 7GB which leaves the rest for the OS.

What have you done to evaluate that the system is slow?  Is it a gut feeling or have you looked at perfmon counters in the OS or wait states in SQL?
0
 
First LastAuthor Commented:
cmangus:

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.
0
 
Chris MangusDatabase AdministratorCommented:
Yes, this is the setting to change.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.