vijaydawda
asked on
Can anybody advise me of performance tuning on windows 2008 running on DL 380 G4 with 12GB , Raid 1 & Raid 5
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).
-tigermatt
ASKER
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