Essbase Performance: Part 5 – Network Storage (Anvil)
Introduction Welcome to part five the Essbase Performance series that will have a lot of parts. Today we’ll pick up where we left off on network storage baselines. Before we get there, here’s a re-cap of the series so far: Essbase Performance Series: Part 1 – Introduction Essbase Performance Series: Part 2 – Local Storage Baseline (CDM) Essbase Performance Series: Part 3 – Local Storage Baseline (Anvil) Essbase Performance Series: Part 4 – Network Storage Baseline (CDM) Essbase Performance In case you’ve forgotten, here’s the list of configurations that will be tested: Eight (8) Hitachi 7K3000 2TB Hard Drives, four (4) sets of two (2) mirrors Eight (8) Hitachi 7K3000 2TB Hard Drives, four (4) sets of two (2) mirrors with an Intel S3700 200GB SLOG Eight (8) Hitachi 7K3000 2TB Hard Drives, four (4) sets of two (2) mirrors with sync=disabled (NFS) or sync=always (iSCSI) One (1) Intel P3605 1.6TB NVMe SSD One (1) Intel P3605 1.6TB NVMe SSD with sync=disabled (NFS) or sync=always (iSCSI) And the four (4) datasets: One (1) dataset to test
Hyperion EPM Week In Review: September 30, 2016
You know you are running late on your Hyperion EPM Week in Review when someone asks you about in on a phone call… It’s been about 10 days since my last week in review, so welcome to this weeks “Hyperion EPM 10 Days in Review.” Hyperion EPM Patches and Updates: Hyperion Financial Reports 11.1.2.4.703 has been released. Looks like mostly bug fixes. The October updates for the cloud will start flowing out next Friday! We have PBCS updates-a-plenty. You can read more about those here. We also have some ARCS updates that you can read about here. Finally, we have FCCS updates that you can read about here. Hyperion EPM Blog Posts: We’ll start off with a post from Robert on the death of on-prem! Well, it may be more of a question, but he has a great headline. Summer has a post about the cloud and how to support your applications. Managed services are becoming far more popular as it becomes more difficult and expensive to find an admin. Dayalan has his third part of
Essbase Performance: Part 4 – Network Storage (CDM)
Introduction Welcome to part four of a series that will have a lot of parts. In our lost two parts we took a look at our test results using the CrystalDiskMark and Anvil synthetic benchmarks. As we said in parts two and three, the idea here is to see first how everything measures up in synthetic benchmarks before we get into the actual benchmarking of Essbase Performance. Before we get into our network options, here’s a re-cap of the series so far: Essbase Performance Series: Part 1 – Introduction Essbase Performance Series: Part 2 – Local Storage Baseline (CDM) Essbase Performance Series: Part 3 – Local Storage Baseline (Anvil) Network Storage Options Today we’ll be changing gears away from local storage and moving into network storage options. As I started putting together this part of the series, I struggled with the sheer number of options available for configuration and testing. I’ve finally boiled it down to the options that makes the most sense. At the end of the day, if you are on local physical hardware, you
My First FreeNAS: Part 2 – Install, Test, and Configure
Re-Introduction It has been quite a while since my last post on my new FreeNAS build. This project was placed on the back-burner while I had a lot going on. I’m finally starting to get everything stabilized, so now I’m back at working on my new FreeNAS box. You can view part 1 of this series here, but just as a quick re-cap, let’s talk about the system specs. Here is a revised list (things in bold have been changed from Part 1): SuperChassis 846TQ-R900B (with Supermicro 1200W model PWS-1K21P-1R) (2) E5-2670 @ 2.6 GHz Supermicro X9DR7-LN4F-JBOD 256GB Registered ECC DDR3 RAM (16 x 16GB) Noctua i4 Heatsinks (5) Noctua NF-R8 (to bring the noise level down on the chassis) (2) SanDisk Cruzer 16GB CZ33 (2) Intel S3500 80GB SSD’s (1) Supermicro AOC-2308-l8e (3) Full-Height LSI Backplates (for the AOC-2308’s and the P3605) (6) Mini-SAS Breakout Cables Intel P3605 1.6TB PCIe SSD (9) 2TB HGST Ultrastar 7K3000 Hard Drives (4) 10Gb Twinax DAC Cables (2) Intel X520-DA2 So why did I make these changes? The power supply
Hyperion EPM Week In Review: September 20, 2016
Last week was clearly the calm before the Oracle OpenWorld storm! This week in Hyperion EPM has been really, really busy! Hyperion EPM Patches and Updates: Hyperion DRM 11.1.2.4.342 is now available. It appears to be a few bug fixes. Hopefully your bug was fixed! Hyperion EPM Blog Posts: Rodrigo continues his series on ODI 12c. This part of the series covers loading dimensions and cubes using natural keys with the promise of a future post on surrogate keys. Sibin had four posts this week. First he covers how to delete a Planning application manually. Next he covers a very specific drill-through issue with FDMEE. Sticking with FDMEE, he moves on to updating the period tables. Finally he continues on with FDMEE and shows off the functionality of drill-through in Planning. Celvin had two posts this week between a long flight and a meeting that doesn’t interest him. First he has an update to his NUMSysCmdLauncher utility that includes some new filter functionality along with a rewrite in Groovy. Next up he has an intro to JSON for
Recovering an Oracle Database from Unexpected Failure
Oracle Database Introduction I’ve been a user, developer, and administrator of SQL Server databases many times over the years. I’m really comfortable with that product and how to fix things when they break. Oracle Database on the other hand, I’ve only ever really been a consumer of information. Someone who writes queries to the data. As I’ve worked to expand my horizons in my lab, Oracle Databases are one of the things that I found very interesting. One things about Oracle Databases that I found surprising is that they do not do well in unexpected shutdowns at all. So, to help those that have an Oracle Database server that really don’t know that much (like me!), I’ve compiled a list of things that have helped me get my system back up and running if I have an unexpected shutdown. Getting Connected in SQL*Plus First, if you have more than one Oracle SID on your server, you need to set ORACLE_SID to the SID you want to work on. This should be simple, unless you are like