How to increase performance of a SQL 2008 R1 running on Server 2008 R2

Posted on 2011-10-28
Last Modified: 2012-05-12
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.
Question by:First Last
    LVL 17

    Accepted Solution

    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?
    LVL 1

    Author Comment

    by:First Last

    Max Memory for SQL: You are referring to this setting?

    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.
    LVL 17

    Expert Comment

    Yes, this is the setting to change.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now