Learn how to a build a cloud-first strategyRegister Now


Can anybody advise me of performance tuning on windows 2008 running on DL 380 G4 with 12GB , Raid 1 & Raid 5

Posted on 2008-11-06
Medium Priority
Last Modified: 2012-05-05
Hi I am running windows server 2008 enterprise & sql 2005 std.  HP DL 380 G4  dual xeon 3.0 Processor,  12 GB of RAM  2 x 72 gb raid 1  for os & 3 x 72 gb raid 5 for data.  somebody advise me to tune the ser for best performance tuning.
Question by:vijaydawda
  • 2
LVL 58

Accepted Solution

tigermatt earned 400 total points
ID: 22906603


If this is a busy SQL database, then you should not be storing and running the database from a RAID 5 array. It should be run from a RAID 10 array and no other; if it works reliably from RAID 5 it can't be a busy database.

Other tweaks I would make would mainly be to ensure that the page file is set to a fixed size. This would usually be 1.5x the size of RAM, but 18GB is probably very large for the page file, so set it to what Windows recommends. When you go to change it, choose a Custom Size, and enter the SAME size for both the initial size and the maximum size. This prevents Windows resizing the file on the fly which can cause performance issues.

Ensure all Windows update are installed and the server is kept patched, and you should be OK on that side of things.


Author Comment

ID: 22911098
Dear Tigermatt,
Thks. for your answer,  I am fully updated with patches,  one more aspect that will be sql 2005 std. be able to take advantage of whole 12 GB  or maximum os can allow it?Vijay
LVL 58

Expert Comment

ID: 22911572

The Operating System in general will only be able to make use of the full 12GB if you have installed and are using the 64-bit edition of Windows Server 2008. If you have the 32-bit edition, only 4GB of RAM can be used - maximum.

So, should you be running the 64-bit edition of Windows Server 2008, then yes, SQL Server can utilise the majority of the 12GB of RAM (some will obviously be used by the Operating System).


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Suggested Courses

810 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