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.


# posted by Edward Whalen @ 8:28 AM
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
# posted by Blogger mattypenny : 4:36 AM
 
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?
# posted by Blogger Unknown : 9:02 AM
 
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.
# posted by Blogger Jeff (no, the other one) : 6:05 PM
 
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.
# posted by Blogger Edward Whalen : 5:03 PM
 
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
# posted by Blogger Juro : 5:06 AM
 
hi!nice to meet you,if you are free welcome to my blog!雙眼皮診所,雙眼皮手術,台中新彩雙眼皮,眼袋,台中眼袋,新彩眼袋,眼袋整形,眼袋手術,眼袋診所,眼袋醫師,狐臭,台中狐臭,新彩狐臭,狐臭整形,狐臭手術,狐臭診所,削骨,台中削骨,削骨整形,削骨醫師,削骨診所,新彩,台中新彩,新彩整形,新彩診所,新彩整形外科,隆鼻,高雄隆鼻,建炳隆鼻,隆鼻手術,隆鼻整形,隆鼻醫師,韓式隆鼻,傳統隆鼻,隆鼻診所,抽脂,建炳,建炳整形,高雄建炳,建炳診所,整形,建炳整形,高雄整形,整形醫師,建炳,建炳整形
# posted by Anonymous Anonymous : 6:39 AM
 
hi!nice to meet you,if you are free welcome to my blog!網路行銷,信律隔熱紙,簡善琳瑜珈,心安居家看護,畯富包車旅遊,三泰保健食品,104法拍屋,信律隔熱紙,禾雅堂乳酪蛋糕,潘朵拉日韓服飾,優質行動網,網路行銷,旅遊達人,旅遊資訊,日光花園,瑜珈天地,小蝸牛,潘朵拉服飾,建炳整形,新彩整形,不孕症達人,優質網,新彩整形,建炳整形,郭鴻璋婦產科,網路行銷,隔熱專家,actionone,機票旅遊,汽車旅館天地,日光花園,瑜珈天地,法拍屋達人,清潔達人,行動百分百,優質天地,百分百,aoone,actionone,首頁科技,新彩整形,建炳整形,嘉俞瑜珈,actionone,seo,seo,seo,seo,seo,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,網路行銷,,台中雙眼皮,新彩雙眼皮,割雙眼皮,縫雙眼皮,韓式雙眼皮,雙眼皮整形
# posted by Anonymous Anonymous : 7:24 AM
 
MOTEL,seo,整形外科,整形,整形,整形,整形,新彩,整形,整形,整形,整形,整形,整形,整形,整形,整形,整形,整形,整形,整形,整形,整形外科,整形外科,整形外科,整形外科,新彩外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,整形外科,seo,seo,seo,seo,seo,seo,seo,seo,seo,高雄MOTEL,汽車旅館,住宿台中,台中汽車旅館,台中motel,高雄汽車旅館,日光花園,MOTEL,高雄日光花園
# posted by Anonymous Anonymous : 7:25 AM
 
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
# posted by Blogger Unknown : 6:51 PM
 
Post a Comment



<< Home

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