Wednesday, January 24, 2007

 

What hardware should I buy?

I recently had one of my blog readers ask me for some advice on some new hardware that he was going purchase for running Oracle on Windows. It is difficult to give specific advice on what to purchase, but I can provide a few general guidelines.

  1. Get something that is expandable. If you don’t need 4 CPUs now you can get a system capable of supporting 4 CPUs, but only purchase one or two. Make sure that you can add sufficient memory as necessary. Start with 2 or 4 GB but make sure that there are free slots in case you need to add more.
  2. If you will be running Oracle 10g, absolutely go 64-bit. Any recent Xeon or Opteron processor supports 64-bit Windows. The 64-bit version of Windows 2003 works great and is priced similar to the 32-bit version.
  3. Get a name brand. HP, IBM, Dell, etc. Get something that is supported by the manufacturer.
  4. If possible, separate the application tier from the database tier.
  5. Get sufficient disk drives. I'm not saying that you need to start with 8, but you need enough so that IO performance is not a problem. How many do you need? I can't tell you without knowing more about the database and application, etc.
  6. Absolutely use a RAID controller and disk mirroring (RAID 1). If you lose your data, you are out of business.
  7. In larger systems I recommend separating the log drives and data drives, since the loss of one of the two is a recoverable failure. The loss of both is catastrophic.
  8. If you don't already have one, get something to back up your database with. This can be tape, DVD, etc..
  9. Get trained, get some books, etc.. I'm trying to convince Oracle Press to let me do an Oracle on Windows book.

I hope that this is helpful. If you have any comments or a suggestion for a future topic, drop me an email at ewhalen@perftuning.com.


Comments:
Good post.

Only thing I would add it that its probably good to work out the licensing costs in conjunction with the hardware. A dual core CPU is typically cheaper to license than two single core CPUs. The doc I refer to is:

http://www.oracle.com/corporate/pricing/ePLext.PDF

HTH
 
Edward,

This is a great article! Thank you!

One question... when installing Oracle on Windows, is there are preferred user type? Is it preferred to install as a domain/AD user, or one who is just a local administrator?
 
Saw a reference elsewhere that advised avoiding putting it on a Domain Controller. Said logon as local administrator. FYI.

Edward, thanks for this! We're just getting started with 10g.
 
I prefer to use a domain user, but you can use a local user if you prefer. It's a good idea to give the domain user local admin rights. Also, I've had problems trying to get Oracle to work on a domain controller, since you can't create local groups. It's just better not to do it.
 
If you want to take full advantage of multiple disk drives, I would suggest to go for a striped RAID, i.e. RAID5 and not RAID1
 
Oracle 10g gives a good overview of those new features and upgrading on that will take advantage of the many features offered on it. There are also an enhancements for oracle 10g and one of it is reducing the costs and providing quality services.


microsoft windows support
 
Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?