Latest Patches, Quick Links, and Presentations

I’ve been tinkering with the site lately and now I think most of the content should be ready to publish.  First, I had someone recently ask for a few of my older presentations, so I figured it was time to organize all of my old presentations and give them a final place to live.   So if anyone went to one of my presentations and wanted the slide deck or addendum, they should all be here going forward.

Presentations Page

As I was going through all of these presentations, I realized just how bad I used to be at PowerPoint (and still am) and how awful some of the Kscope templates have been over the years.  With that, I decided to move on to tweaking the Quick Links pages to move the environment links into a table and generally format things better.

Quick Links

Finally, I decided to add a new page that tells us first, what are the most recent patches and second, what are ALL of the patches 11.1.2.4.  So here it is…

Latest Patches

I managed to capture everything from 11.1.2.4, but I did not venture back to 11.1.2.3 or earlier.  So if you are looking that far back…I prioritized sleep over compiling that giant list.


Building a Hyperion Home Lab: Putting It All Together

Before we get started, here’s the entire series in case you need to look back (or ahead):

Now that we’ve made it through all of the different components, let’s summarize everything so that we can get a clear view of the total budget and what exactly it is that we get for the money we are spending.

Our final selections are summarized in a table below each of budget options, so I’ll try to just re-cap each option.

Desktop High Buget

For our high budget option, we are looking at higher end of consumer hardware.  We have a high end desktop Intel processor (4 cores and 8 threads), a feature-filled motherboard, 64 GB of RAM, 1 TB of SATA SSD storage, 512 GB of NVMe SSD storage, and 4 TB of back-up storage.  All of this leaves us with a total of $1,927.18.  Here are the details:

Intel Core i7 6700k$414.991$414.99Link
ASRock Z170M Extreme4$124.991$124.99Link
G.SKILL Ripjaws V Series 64GB$394.991$394.99Link
Fractal Design Define Mini$95.991$95.99Link
SeaSonic S12G S12G-550$79.991$79.99Link
Samsung 850 EVO 1 TB$329.991$329.99Link
Samsung 950 Pro 512 GB$326.251$326.25Link
HGST Deskstar NAS 4 TB$159.991$159.99Link
Total Desktop High Budget $1,927.18

Desktop Medium Budget

We have two options for our medium budget.  They both provide a upper-end Intel processor (4 cores, 4 threads), the same mid-range motherboard, 1 TB of SATA SSD storage, 256 GB of NVMe SSD storage, and 3 TB of back-up storage.  The difference between the two is memory.  Both offer up 32 GB of RAM, but the more expensive option two chooses to use two 16 GB modules instead of four 8 GB modules.  The price difference is relatively low with option one coming in at $1,248.91 and option two (which is again expandable to 64 GB in the future) coming in at $1,298.92.

Details for option 1:

Intel Core i7 6700$349.991$349.99Link
ASRock H170M Pro4$84.991$84.99Link
Crucial 16GB (2 x 8GB)$64.992$129.98Link
Cooler Master N200$46.991$46.99Link
SeaSonic S12G S12G-550$79.991$79.99Link
SanDisk Ultra II 960 GB$249.991$249.99Link
Samsung 950 Pro 256 GB$181.991$181.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Desktop Medium Budget Option 1 $1,248.91

Details for option 2:

Intel Core i7 6700$349.991$349.99Link
ASRock H170M Pro4$84.991$84.99Link
G.SKILL Ripjaws V Series 32GB (2 x 16GB)$179.991$179.99Link
Cooler Master N200$46.991$46.99Link
SeaSonic S12G S12G-550$79.991$79.99Link
SanDisk Ultra II 960 GB$249.991$249.99Link
Samsung 950 Pro 256 GB$181.991$181.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Desktop Medium Budget Option 2 $1,298.92

Desktop Low Budget

For our low budget desktop, we’ll stick with a single option.  This option provides a lower-end but still quad core processor, a lower-end motherboard, only 16 GB of RAM, and a single 3 TB hard drive.  The upside is that this can easily support an SSD and an upgrade to 32 GB of RAM for a moderate increase in price.  But, as optioned, we’re looking at $499.94.  I didn’t even plan on that being under $500…

Intel Core i5 6400$189.991$189.99Link
ASRock H110M-HDS$51.991$51.99Link
Crucial 16GB (2 x 8GB)$64.991$64.99Link
Rosewill FBM-01$27.991$27.99Link
EVGA 100-W1-0430-KR 430W$39.991$39.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Desktop Low Budget$499.94

Server High Budget

Now on to the fun stuff…servers.  Our high end server was intended for the audience that wants brand new hard ware on the latest server technology.  This gives us a pair of six-core processors (with 12 threads), 128 GB of DDR4 RAM, a fancy hot-swap case that supports 24 drives, 1 TB of SATA SSD storage, 400 GB of Enterprise-class NVMe SSD storage, and 4 TB of back-up storage.  All for the low, low price of $3,769.90.  The parts list in all of its glory:

Intel Xeon E5-2620 V3$429.992$859.98Link
Supermicro MBD-X10DAI-O$389.991$389.99Link
Crucial 64GB (4 x 16GB) Registered ECC DDR4$449.992$899.98Link
NORCO RPC-4224$429.991$429.99Link
SeaSonic G-750 SSR-750RM$119.991$119.99Link
Samsung 850 EVO 1 TB$329.991$329.99Link
Intel P3600 400 GB$579.991$579.99Link
HGST Deskstar NAS 4 TB$159.991$159.99Link
Total Server High Budget $3,769.90

Server Medium Budget

Ok…now that we have the insanely expensive option of the way, we can go back to reasonable.  So how do we get the performance of insanely expensive but the price of a desktop machine?  Head to Ebay for processors and RAM, and then get all new hardware for everything else.  What we end up with are two options.  Both options include a pair of eight-core processors (with 16 threads), a nice dual processor motherboard with quad-gigabit lan, 1 TB of SATA SSD storage, 400 GB of NVMe SSD storage, and 3 TB of back-up storage.

With option one, we have chosen to go with lower cost 8 GB modules for a total of 128 GB of RAM and a desktop case.  The total price for this option is $1,849.94.  For option two, we swap out the 8 GB modules for 16 GB modules and throw it into a 4U rackmount case.  The total price for this option is $2,721.94.

Details for option 1:

Intel Xeon E5-2670$150.002$300.00Link
ASRock EP2C602-4L/D16$309.991$309.99Link
Ebay 16 x 8GB DDR3$20.0016$320.00Link
Phanteks PH-ES614PC_BK$94.991$94.99Link
SeaSonic G-750 SSR-750RM$119.991$119.99Link
SanDisk Ultra II 960 GB$249.991$249.99Link
Intel 750 400 GB$329.991$329.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Server Medium Budget Option 1 $1,849.94

Details for option 2:

Intel Xeon E5-2670$150.002$300.00Link
ASRock EP2C602-4L/D16$309.991$309.99Link
Ebay 16 x 16GB DDR3$75.0016 $1,200.00 Link
NORCO RPC-470$86.991$86.99Link
SeaSonic G-750 SSR-750RM$119.991$119.99Link
SanDisk Ultra II 960 GB$249.991$249.99Link
Intel 750 400 GB$329.991$329.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Server Medium Budget Option 2 $2,721.94

Compared to the high server budget, either option is practically a steal.  For almost $2,000 less, we get the same memory capacity (albeit DDR3) and more processor cores (albeit a little slower and a little hotter).  So the question is…do you really need new an shiny that much?  Only you can decide.  I’ve built both (new and shiny, and Ebay Frankenstein), so I get it.  I have both sitting in my home lab and I can say I’m actually very happy with both systems.  With the options available now..I’m going with Ebay Frankenstein.

Server Low Budget

For our low budget server, we get a quad core single socket Xeon processor (with 4 threads), 32 GB of RAM (expandable to 64 GB for $229.98), 1 TB of SATA SSD storage, and 3 TB of back-up storage.  Not bad for $1,180.41.  The parts list:

Intel Xeon E3-1220 V5$218.481$218.48Link
Supermicro X11SSH-F-O$229.991$229.99Link
Samsung DDR4-2133 16GB$114.992$229.98Link
Cooler Master N200$46.991$46.99Link
SeaSonic S12G S12G-550$79.991$79.99Link
SanDisk Ultra II 960 GB$249.991$249.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Server Low Budget $1,180.41

Tiny Server

Finally, and most tiny, we have our tiny sever option.  This server packs a huge punch in a little package and a decent cost.  We get a quad core processor (with 8 threads), 64 GB of RAM (expandable to 128 GB for $479), 1 TB of SATA SSD storage, and 3 TB of back-up storage.  Again, not bad for $1,504.94.  Check out the tiny parts list:

Intel Xeon D-1520$489.991$489.99Link
Supermicro MBD-X10SDV-4C-TLN2F-O$0.001$-Link
Supermicro 32GB DDR4$239.992$479.98Link
Supermicro CSE-721TQ-250B$159.991$159.99Link
SanDisk Ultra II 960 GB$249.991$249.99Link
HGST Deskstar NAS 3 TB$124.991$124.99Link
Total Tiny Server Budget $1,504.94

So which server will you build?

I hope this series has been helpful for those of you really interested in a Hyperion Home Lab.  Now we can get back to Powershell and some of the great things I have planned for my home lab.


The EPM Week In Review: Week Ending February 20, 2016

Two weeks…two weeks in review.  Let’s see how long we can keep this up!

Patches and Updates:

The Essbase 11.1.2.4.007 patch has been released.  This comes with a server patch along with the various client patches.  There are a few interesting features including the QUERYRESULTLIMIT for preventing stupid ASO user tricks and a few other ASO related bugs.  Now if they can just release .008, which has a bug I need fixed…that would be great.

Financial Reporting 11.1.2.4.006 has been released.  Nothing too interesting here…just bug fixes.

Blog Posts:

This week I discussed storage for your Hyperion Home Lab.  I also posted about the Admin Console and created a new Quick Links page on the site.

Dave reminds us that our grace period for 11.1.2.3.700 is coming up soon here.

Harry let’s us know that he has released a new version of his cubeSavvy Utilities.  He lost me when he started speaking Russian…but hey I barely speak English.

Dmitry has an interesting write-up on Drill-Through performance in Essbase here.

Sarah gives us a nice lesson in UNIX and Windows Interoperability.

Tony shows off a very detailed guide to using DRM and PBCS.

For those in the cloud that can use Valid Intersections, Celvin shows us that they can be automated!

Other News:

ODTUG is now accepting applications for their Women in Technology Scholarship.  You can find out the details to the program here.  Applications are due in a little over a month on March 22, 2016.

As always (twice anyway), if I missed a great blog post or a patch release, let me know and I’ll either update this post or add it to next week’s post.  Have a great weekend everyone!


Random Tip: Using WebLogic Admin Server to Monitor Services

Happy Friday!  There’s nothing quite like needing to restart one or all of your EPM services.  First you have to shut it all down and make sure it’s actually down.  Then you have to start it up in the right order and then you have to make sure it’s actually up before you send users back in.  Lately, I’ve started using the WebLogic Admin Server to help me with this in my Home Lab.

Let me start by saying that I am NOT an infrastructure guy.  I work with a lot of infrastructure guys and have done a lot of personal installs in my home lab, but I’m an applications guy.  So…if someone on the infrastructure side says this is a horrible idea, I’ll let you take it up with them.

Now that we have that out of the way, let’s get to how we use the Admin Server.  As a little bit of a background story, when your installation was completed, you were likely deployed to multiple servers.  My deployment is pretty distributed, so I have server for Planning, HFM, Essbase, Shared Services, etc.  Each time those servers are configured, they have to be registered with the Admin Server.  Once that is complete, the Admin Server doesn’t necessarily need to be running any more, so you may need to start it up.

To start the admin server, find Start Admin Server for Weblogic Server Domain shortcut in the Start Menu on your Foundation Server.  It should be named this on both 11.1.2.3 and 11.1.2.4.

WAS 01

Once you click on that shortcut, a command prompt should start up letting you know what’s going on.  Eventually, you should get a message saying that the server has changed to a RUNNING state:

WAS 02

Now we can go find the shortcut for the Admin Server Console in the start menu:

WAS 03

This should open up your browser to the Admin Console login screen:

WAS 04

Log in here using youe Weblogic Domain Admin account (typically epm_admin).  Once you get logged in, you should see this:

WAS 05

This is 11.1.2.3.500, so it may look moderately different on 11.1.2.4.  Let’s stop here for a general warning:

You can do all sorts of things in this console that could do something bad to your environment.  So be careful.  I just look around…I don’t change things!

Once you see the screen above, expand Environment and then click on Servers:

WAS 06

This should give you a list of all of your services, clusters, machine names, service states, and even the listening ports:

WAS 07

That’s neat and all, but why do I really care outside of seeing service health?  Well, when I restart, I’m impatient, but i don’t really want to try out Workspace until I’m sure everything is up.  So I end up waiting longer than I need to most of the time.  And again, I’m impatient.  So on my 11.1.2.4 environment I needed to stop and restart Planning.  So first let’s see what it looks like when I have a stopped service:

WAS 08

Now let’s look at the HyperionPL24.hyperion.local services console:

WAS 09

It is in fact down.  It also needs to be switched to manual…but I’ll work on that later.  So let’s go ahead and restart the service:

WAS 10

That was easy!  It’s already running!  Except that we all know that the services console lies.  It’s not really running, its just running the process that starts the process.  So how do we know when it’s really started?  Option 1…we can go old school and look at the service logs.  It will eventually update to say that the state has been changed to RUNNING.  Option 2…we can just go see if it’s there in Workspace.  Call me paranoid, but I always feel like I’m going to break something if I don’t wait until it’s done.  Option 3…refresh the admin server list from above.  It will eventually register that it’s STARTING:

WAS 11

And finally let you know that its RUNNING:

WAS 12

I’m sure that there are plenty of other cool and interesting things that we could break do with the Admin Console, but this is my simple use.  I hope some of you find this helpful, or at the very least…interesting.


New Quick Links Page

I decided to add a new Quick Links page to the site.  Like many of you, I go from version to version and environment to environment a lot.  This page includes links to all of the active documentation libraries on the Oracle site.  This page also includes the links to the various harder-to-find products like the EAS web console and the Financial Reports mobile site.  You can find it here:

Quick Links

And a preview:

Full DocsEssbase Tech RefEssbase DBAGPlanning Admin GuideHFM Admin GuideFDMEE
11.1.2.4





11.1.2.3





11.1.2.2




11.1.2.1
11.1.1.4



9.3.x

9.2.1


I’d love to expand this page to include other useful information, so feel free to speak up and let me know what I’m missing!  I actually already used this page tonight…twice before getting it fully posted.


Building a Hyperion Home Lab: Choosing Your Storage

Before we get started, here’s the entire series in case you need to look back (or ahead):

It’s finally time for the last piece of our Home Lab before we put it all together.  Where do we store our data?  There are three main areas that come to mind when we start to put together our storage system:  virtual hard drive storage, high performance storage, and backup storage.

First we need a place to store the operating system and installed software for each of our guest virtual machines.  With the prices of SSD’s coming down every day, it’s hard not to go that route for our main storage.  This is, after all, going to make everything run very fast.

Next, we need some high performance storage.  This might still just be SSD storage, or we might want to go with something faster.  Maybe RAID or NVMe (we’ll get to this).  But when we look at certain applications where disk I/O is important (our databases like Essbase and our Repositories), we might want something faster than our standard storage.

Finally, we should back things up.  This is where we will safely leave SSD’s and go straight to old-school magnetic storage.  For each of our budget options, we’ll have a slightly different overall configuration.  Let’s get started.

Desktop High Budget

For our high budget option, we’ll choose a drive for each of the above areas of concern.  We’ll have a large SSD for our virtual machines, and NVMe drive for our high performance area, and a big magnetic drive for our backups.  For our main SSD drive, I prefer the Samsung 850 EVO 1TB drive.  This drive has impressive performance and longevity making use of the latest in flash technology.  With 540 MB/s sequential reads, 520 MB/s sequential writes, 98,000 IOPS for random reads, and 90,000 IOPS for random writes…this drive is pretty great for $329.99.

For our high performance drive, we’ll stick with Samsung, but we’ll upgrade to an NVMe drive.  But wait, what’s an NVMe drive and why do we care?  Our regular SSD drive will connect to a SATA3 port.  SATA3 maxes out at 6 gigabits of bandwidth.  NVMe on the otherhand is designed to run directly on the PCIe bus.  This means that we have four lanes of PCIe 3.0 to work with.  PCIe provides 975 megabytes (not bits) of bandwidth per lane.  That means we have nearly four gigabytes (not bits) or bandwidth to play with for our NVMe device.  The specific NVMe drive I’ve chosen Samsung 950 Pro 256GB drive, priced at $326.25.  If you think the EVO was fast, the 950 Pro sports 2,500 MB/s sequential reads, 1,500 MB/s sequential reads, 300,000 IOPS for random reads, and 110,000 IOPS for random writes.

And now for our nice slow, but plentiful back-up drive.  HGST makes a nice NAS-rated 4 TB drive for $159.99.  It’s a 7200 RPM drive, so it will provide pretty good sequential performance for our back-up needs.

Desktop Medium Budget

For our medium budget option, we’ll stick with an SSD for our main drive, but we’ll go a little cheaper.  The SanDisk Ultra II provides great performance at a much lower price of $249.99 (if you are lucky, you can find them on sale under $200 occasionally).  The performance on this drive is 550 MB/s sequential reads, 500 MB/s sequential writes, 99,000 IOPS for random reads, and 83,000 IOPS for random writes.  I have one of these drives in my new ESXi box and it’s a solid performer.

For our high performance drive, we’ll just stick with the Samsung, but cut the space and cost in half.  At $181.99, the 256 GB version of the 950 Pro sports 2,200 MB/s sequential reads, 900 MB/s sequential reads, 270,000 IOPS for random reads, and 85,000 IOPS for random writes.  Still crazy fast…

And for our back-up drive, we’ll cut the costs a little and go with a smaller version of the same drive that our high budget option uses.  At $124.99, we’ll save a little money and just keep a smaller number of running back-ups.

Desktop Low Budget

For our low budget option, we’ll do things a little different.  As cost is our primary issue here, we’ll stick with a single drive.  We’ll stick with the 3 TB HGST NAS drive at $124.99.  This gives us some flexibility with the number of VM’s we can handle and it will still be plenty fast for our goal of learning new technology.

Server High Budget

For our server choices, things will change…but just a little.  We’ll stick with our Samsung 850 EVO 1 TB drive for our main drive.  The 850 Pro is a good choice, but it’s hard to justify the additional cost, so we’ll stick with the EVO.

For our performance drive, we’ll definitely change things up.  We’ll go with the Intel DC P3600.  This is actually the same drive several models of the Oracle Exalytics systems use and re-brand as a Sun Flash Accelerator.  It’s a straight PCIe card rather than an M.2 SSD since we don’t have that type of slot using in our server options.  The 400 GB drive cost $579.99 and provides 2,100 MB/s sequential reads, 550 MB/s sequential reads, 320,000 IOPS for random reads, and 30,000 IOPS for random writes.

For our back-up drive, we’ll stick with the 4 TB model at $159.99.

Server Medium Budget

In our medium option, we’ll go back to our desktop medium option where we find our SanDisk drive at $249.99.  This is a great option for our lower cost server option.

For our performance drive, we’ll stick with Intel, but we’ll go the Intel 750 drive.  At $329.99, it provides 2,200 MB/s sequential reads, 900 MB/s sequential reads, 430,000 IOPS for random reads, and 230,000 IOPS for random writes.  So it’s cheaper and faster than the P3600.  What gives?  Those are peak numbers…and it’s all about firmware.  In reality, the P3600 can outpace the 750 in real-world server-level duty loads.  The P3600 is also more over-provisioned giving it a longer life.

Like our medium desktop, we’ll stick with the 3 TB HGST drive at $124.99.

Server Low Budget and Tiny Server

For our low budget and our tiny server, we’ll stick with the Ultra II 960 GB drive at $249.99 and our HGST 3 TB back-up drive ast $124.99, but we’ll ditch the performance drive altogether.  We’ll just keep it nice and simple.

And now…some pretty tables:

Base Storage:

OptionDrivePriceCapacityS-ReadS-WriteR-ReadR-WriteLink
Desktop HighSamsung 850 EVO 1 TB$329.99 1,000 540520 98,000 90,000 Link
Desktop MediumSanDisk Ultra II 960 GB$249.99960550500 99,000 83,000 Link
Desktop LowHGST Deskstar NAS 3 TB$124.99 3,000 164154Link
Server HighSamsung 850 EVO 1 TB$329.99 1,000 540520 98,000 90,000 Link
Server MediumSanDisk Ultra II 960 GB$249.99960550500 99,000 83,000 Link
Server LowSanDisk Ultra II 960 GB$249.99960550500 99,000 83,000 Link
Tiny ServerSanDisk Ultra II 960 GB$249.99960550500 99,000 83,000 Link

High Performance Storage:

OptionDrivePriceCapacityS-ReadS-WriteR-ReadR-WriteLink
Desktop HighSamsung 950 Pro 512 GB$326.25512 2,500 1,500 300,000 110,000 Link
Desktop MediumSamsung 950 Pro 256 GB$181.99256 2,200 900 270,000 85,000 Link
Server HighIntel P3600 400 GB$579.99400 2,100 550 320,000 30,000 Link

Back-Up Storage:

OptionDrivePriceCapacityS-ReadS-WriteR-ReadR-WriteLink
Desktop HighHGST Deskstar NAS 4 TB$159.99 4,000 164154Link
Desktop MediumHGST Deskstar NAS 3 TB$124.99 3,000 164154Link
Server HighHGST Deskstar NAS 4 TB$159.99 4,000 164154Link
Server MediumHGST Deskstar NAS 3 TB$124.99 3,000 164154Link
Server LowHGST Deskstar NAS 3 TB$124.99 3,000 164154Link
Tiny ServerHGST Deskstar NAS 3 TB$124.99 3,000 164154Link

Now that we have all of our hardware picked out, we can add up the total costs in our next post and see the total damage.


The EPM Week In Review: Week Ending February 13, 2016

Welcome to the inaugural post of what I hope to make a weekly post collecting all of the news and information that was produced in the past week.  We’ll see how this goes…

Patches and Updates:

DRM 11.1.2.4.330 has been released.  It does require a password to download, but it is supposed to include the DRM Analytics that many have been waiting for.  Check it out here.

Hyperion Shared Services 11.1.2.002 has been released.  Check it out here.

Blog Posts:

This week I discussed chassis and power supply selection for your Hyperion Home Lab.

Sarah showed off the new data export command that allows for data to be sanitized.

Tim tells us what we can expect when working with block density.

Cameron is letting Philip take over his blog again, this time discussing Smart Push in PBCS.

John Goodwin continues his excellent series around Essbase Web Services.

Kevin over at In2Hyperion shows us how to map Smart Lists to dimensions.  This is a handy feature in PBCS until we finally get real attribute dimensions (I hear this is coming in March).

Other News:

Tony has a new book out on FDMEE.  This one will definitely be in my Amazon cart soon.

Note bad for a first try at a weekly re-cap…if I do say so myself.  If I missed a great blog post or a patch release, let me know and I’ll either update this post or add it to next week’s post.  Have a great weekend everyone!

 

 


Building a Hyperion Home Lab: Choosing Your Chassis and Power Supply

Before we get started, here’s the entire series in case you need to look back (or ahead):

We’re slowly nearing the exciting completion of our new Hyperion Home Lab!  Now that we have all of the key components (besides storage), we need something to power our lab and a place for it to call home.  Cases are all about where you plan to put the system and what’s going in it.  Power supplies, and making sure that you make a quality choice is far more important.  I’ve made sure that I’ve only selected power supplies that I would trust in my own systems.

Desktop High Budget

Because all of our desktop options utilize Micro-ATX form-factor motherboards, this entire section is interchangeable.  For our high budget option, I’ve selected the Fractile Design Define Mini.  This is a great case with good airflow and a great layout in general.  It also has excellent expandability for a Micro-ATX case with six (6) 3.5″ hard drive bays (SSD compatible) and two (2) external 5.25″ bays.  This case is also compatible with Mini-ITX motherboards should you have a tiny server you would like to fit in there.  At $69.99, this case is really a great deal.  If I had a Micro-ATX system to build, this is the case I would go with.

For our power supply, I’ve chosen the SeaSonic S12G S12G-550.  Perhaps among the worst-named components out there, this is a very solid power supply that produces 550 Watts and carries an 80 PLUS Gold certification.  This basically means that it is insanely efficient.  At $79.99, it actually costs more than our case choice.  But as a I mentioned, power supplies are far more important from a quality perspective.  I have several SeaSonic power supplies and I’ve always had great luck with them.

Desktop Medium Budget

For our medium option, we’ll cut the budget down to $47.99 with the Cooler Master N200.  This is another case with a great layout and airflow design.  It has a giant intake fan along with space for two (2) 3.5″ hard drives and two (2) 2.5″ hard drives.  It also has two (2) external 5.25″ bays for additional expansion.  Like the prior choice, it also supports Mini-ITX.  If you need a few more hard drives, you may want to go with the slightly higher priced Fractile Design case, but outside of that, it is definitely a solid choice for any of our budgets.

For our power supply, we’re going to stick with the SeaSonic S12G, and we’ll just leave it at that…

Desktop Low Budget

For the absolute cheapest option, check out the Rosewill FBM-01.  At $29.99, it definitely has cost going for it.  It has two (2) internal 3.5″ hard drive bays, two (2) external 5.25″ bays, and one (1) internal 3.5″ hard drive bays.  This is about as traditional of a design as you will find.  But…it gets the job done at a low cost and provides some expansion options.

For our power supply, this is where things get a little more interesting.  I did a lot of research and found that the EVGA 100-W1-0430-KR is a great low cost option that is pretty high quality.  It’s not perfect, but is at least trustworthy.  It can be found for $39.99 along with a $20 rebate.  It’s hard to beat for effectively $19.99.

Server High Budget

Once you get to servers…things again change.  Our top two options use rather large motherboards, so let’s move on from Micro-ATX and into the land of Extended-ATX and EEB.  For our high budget option, we’re going all rack.  I’ve chosen a case that I’ve used for many years, the Norco RPC-4224.  This supports 24 hot-swap 3.5″ bays that are 2.5″ compatible out of the box.  Each row of four drives connects with an SFF-8087 connector which allows for great flexibility in how the 24 drives can be connected.

When we talk about power supplies, we have to remember that this is a home lab.  For that reason, I went with a consumer power supply for this option.  The SeaSonic G-750 SSR-750RM is a 750 Watt power supply with dual 8-pin CPU connectors.  This is specifically important for our server options with dual CPU’s.  It is also an 80 PLUS Gold certified power supply which brings along with it excellent efficiency.

Server Medium Budget

As we move down the budget scale towards our medium option, I’ve chosen to given a couple of choice for the chassis.  Our first option is also a great choice for our high budget option if you want to stay away from rackmounted equipment.  The Phanteks Enthoo Pro is the case that a colleague of mine used his build that prompted me to publish this series.  He wanted a regular case that would fit a giant motherboard and provide plenty of expansion.  At $94.99 and with six (6) 3.5″ bays, one (1) 2.5″ bay, and three (3) external 5.25″ bays, you can load this thing up with drives and a giant motherboard.  It has an excellent layout and great airflow.

For our second option, we go back to the rack.  This time we go with a much lower cost Norco option, the RPC-470.  This is a great 4U rackmount option that has a lot of expansion for the cost.  At $86.99, this case supports ten (10) 3.5″ bays and three (3) 5.25″ external bays.  If you don’t really care about hot-swap bays and you want to go rackmount, this is the case to go with.

For our power supply…let’s just stick with SeaSonic G-750.

Server Low Budget

We’ll go back to a desktop favorite for our low budget server.  Because we chose a Micro-ATX board, we can again go with any of our desktop options.  Our choice is the Cooler Master N200.

And for the power supply, we’ll go back to the desktop options to the SeaSonic S12G.

Tiny Server

The tiny server gives us a whole host of options given the Mini-ITX form factor.  First, we’ll look at the Supermicro CSE-721TQ-250B.  With a name like that, who wouldn’t choose it?  This case is specifically designed for the Xeon D platform.  It’s compact, comes with a matched high-efficiency 250 Watt power supply, and is reasonably priced at $159.99.  It has four (4) hot swap 3.5″ bays and two (2) stationary 2.5″ bays.  This lines up nicely with our six ports of SATA3 on our Tiny Server choice of motherboard.  And, again, this chassis comes with a power supply, so we can stop there.  Of course, the first two options in our desktop section would also do the trick, as they support Micro-ATX.

And here are our options in a nice pair of tables:

Chassis

OptionChassisPriceLink
Desktop HighFractal Design Define Mini$95.99Link
Desktop MediumCooler Master N200$46.99Link
Desktop LowRosewill FBM-01$27.99Link
Server HighNORCO RPC-4224$429.99Link
Server Medium Option 1Phanteks PH-ES614PC_BK$94.99Link
Server Medium Option 2NORCO RPC-470$86.99Link
Server LowCooler Master N200$46.99Link
Tiny ServerSupermicro CSE-721TQ-250B$159.99Link

Power Supplies

OptionPower SupplyPriceLink
Desktop HighSeaSonic S12G S12G-550$79.99Link
Desktop MediumSeaSonic S12G S12G-550$79.99Link
Desktop LowEVGA 100-W1-0430-KR 430W$39.99Link
Server HighSeaSonic G-750 SSR-750RM$119.99Link
Server MediumSeaSonic G-750 SSR-750RM$119.99Link
Server LowSeaSonic S12G S12G-550$79.99Link

And now…we have a place for our home lab to live.  The end is near!  Next up…storage options.  This should be interesting with all of the new options out there these days between standard SSD’s and NVMe hitting the market with a giant surge in performance.  Can’t wait!


Brian @ KScope 16

As the year rapidly passes me by, I realize that KScope isn’t really that far away.  I hope to meet many of in Chicago this June!  I’ve been very fortunate to have two presentations selected again this year:

PBCS Is Still Hyperion Planning

Date, Time, and Session # TBD

With Oracle’s release of PBCS, many services companies have started releasing their one-size-fits-all implementations. The unfortunate truth is that PBCS is still Hyperion Planning. This presentation discusses the best practices around implementing PBCS and how to avoid the pitfalls of implementations offered at insanely cheap (and underestimated) pricing. Attend this session if you don’t want to have your PBCS project “land and expand.”

The Planning Repository Revisited: Beyond the Basics

Date, Time, and Session # TBD

If you’ve enjoyed my past presentations on the Planning repository, you should enjoy this presentation even more. We’ll take a step beyond the basics and provide a whole new set of examples that take a leap into real-world use. Whether it’s synchronizing metadata across applications or deleting dimensions, this presentation will dive deeper than ever before into the repository. But wait…there’s more. This presentation will have full samples in both Transact SQL for SQL Server users and PL/SQL for Oracle users. That’s two languages for the price of one (shipping and handling not included).

And here:

http://kscope16.com/presenters/presenterlist?last_id=137

I’ll update this post once we have dates and times.  Looking forward to Chicago!


Building a Hyperion Home Lab: Choosing Your Memory

Before we get started, here’s the entire series in case you need to look back (or ahead):

We have our first two major components, but now we need memory.  After all, memory is what Hyperion craves, and each release seems to need that much more.  Each of our budget options has a different level of capacity and functionality.  Today we’ll look at an option for memory for each configuration, but keep in mind that memory is a highly volatile market and that prices at the time of publishing this blog may change significantly.

So let’s get started…

Desktop High Budget

As we’ve discussed, all of our desktop options will max out at 64 GB of RAM.  In the future, I hope to update the high budget option to use the next generation of high-end desktop processors.  These processors will have higher core counts and support at least 128 GB of RAM.  But…for now, we are stuck with 64 GB.  The cheapest option I’ve found so far is the G.SKILL Ripjaws V Series 64 GB Kit.  This kit includes four (4) DDR4 modules at 16 GB a piece and is priced at $394.99.  You will see a lot of different options out there around DDR4 speeds, but unless you are a serious gamer and this is a multi-use system, go with inexpensive, as you are unlikely to see a difference in a home lab.

Desktop Medium Budget

For our medium budget configuration, we will go with 32 GB of RAM.  This is where the options get a little more complex.  The cheaper option is to go with four (4) modules of 8 GB.  This can be found for as cheap as  $129.98 (two Crucial 16 GB kits at $64.99 each).  Alternately, we can choose to use two (2) sticks of 16 GB.  This allows us to have 32 GB now and eventually upgrade to 64 GB without needing to replace all of our memory.  We can use the 32 GB version of our high budget option: the G.SKILL Ripjaws V Series 32 GB Kit.  The price difference isn’t substantial at $179.99.

Desktop Low Budget

The Crucial 16 GB kit is a great choice for our low budget option as well at $64.99.  The downside of course is that 16 GB of RAM is only enough to do so much with virtual machines.

Server High Budget

Servers are a little bit of a different animal when it comes to memory.  First, most of them require ECC RAM.  ECC stands for Error Checking and Correcting.  In theory, you can run regular RAM in a server, but your maximum memory goes down to desktop levels, so very few people ever do it…even in a home lab.

Some servers also require registered RAM.  Essentially, we use unbuffered RAM in desktop applications and some server types while we use registered RAM for the rest of our server types.  We have a bit of a mix in our server options, but all of them use ECC RAM.

In our high budget option, we want a lot of RAM.  The challenge is that server motherboards not only want Registered and ECC RAM, but they are often times very picky about brands and speeds of RAM.  This is why the motherboard manufacturers publish a list of certified memory.  At the same time, memory manufacturers publish a list of motherboards compatible with their memory.  This means that we should try to find memory on one of those two lists for our motherboard of choice.

The Crucial 64 GB Kit (16 GB x 4) is guaranteed by Crucial to be 100% compatible with our Supermicro X10DAi motherboard selection.  This is also one of the cheaper sets available at $449.99.  For our high budget option, I suggest a pair of these kits to give you 128 GB of RAM with the ability to expand to 256 GB using another pair in the future.

Server Medium Budget

The medium budget option is a little more complicated.  For one, we won’t be going to Newegg to get our RAM.  We could, but it would cost twice as much, or more.  Instead we’ll be watching Ebay looking for the right RAM for our motherboard.  I have two of the ASRock motherboards that I recommended.  One is running Kingston RAM and the other is running Crucial RAM.  Samsung and Hynix should both be pretty good as well.  So what do we look for on Ebay?  If we want the absolute best bang for the buck, we are looking for sixteen (16) stick of 8 GB of registered ECC DDR3.  These should be readily available for $15-$20 per stick depending on your patience level.  That means for 128 GB of RAM, we only need to spend a little north of $300 depending on the deal you find.

The downside to this option is that we will fill our motherboard to capacity and only get 128 GB of RAM.  So our second option is to find eight (8) sticks of 16 GB.  The downside here is going to be cost and availability.  The 8 GB sticks are literally everywhere.  The 16 GB sticks are there as well, but the cost varies greatly.  With enough patience, you should be able to find these sticks for $70-$80 each.  Notice that our cost is not double, but quadruple that of our 8 GB sticks.  So for the same 128 GB of RAM, we pay roughly double the cost.  For that doubled cost we have the ability to expand one day to 256 GB of RAM.  Is it worth it?  I’ll leave that up to you and your significant other to decide.

Server Low Budget

For our low budget option, I’d recommend picking up a pair of 16 GB modules made by Supermicro.  They are $114.99 per ECC module and are certified to work on our motherboard selection.  This gives us 32 GB to start and allows us to later upgrade to 64 GB without needing all new memory.

Tiny Server

Our tiny server option is a bit interesting.  While it may be tiny, it packs a serious punch and has some impressive options for memory expansion.  Maxing out at 128 GB of RAM, we can really go as low or as high as we want.  For the purposes of this guide, I’ll assume that 64 GB is a good starting point, and you can always add more later if we use the right modules of RAM.  So what’s the right module of RAM?  Supermicro makes one just for this purpose.  For $239.99, you get 32 GB of RAM on a single stick.  So we’ll go with a pair of those for our tiny server with a total cost of $479.99.

Just to summarize…here are all of our memory choices with specific pricing and links to purchase what you need.  Next up…we need a place to put all of this nice new hardware and a way to power it up.  Stay tuned…

OptionMemoryTypeTotal MemoryPriceQtyTotalLink
Desktop HighG.SKILL Ripjaws V Series 64GBDDR464 GB$394.991$394.99Link
Desktop Medium Option 1Crucial 16GB (2 x 8GB)DDR432 GB$64.992$129.98Link
Desktop Medium Option 2G.SKILL Ripjaws V Series 32GB (2 x 16GB)DDR432 GB$179.991$179.99Link
Desktop LowCrucial 16GB (2 x 8GB)DDR416 GB$64.991$64.99Link
Server HighCrucial 64GB (4 x 16GB) Registered ECC DDR4DDR4128 GB$449.992$899.98Link
Server Medium Option 1Ebay 16 x 8GB DDR3DDR3128 GB$20.0016$320.00Link
Server Medium Option 2Ebay 16 x 16GB DDR3DDR3256 GB$75.0016 $1,200.00 Link
Server LowSupermicro X11SSH-F-ODDR432 GB$114.992$229.98Link
Tiny ServerSupermicro MBD-X10SDV-4C-TLN2F-ODDR464 GB$239.992$479.98Link