• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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.
0
First Last
Asked:
First Last
  • 2
1 Solution
 
Chris MangusDatabase 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now