Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

No matter what the scope of an engagement covers, no matter what technology we’re asked to support, Datavail helps organizations leverage data for business value. Transform your firm’s performance, processes, decision making and more with tour technology support.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Datavail runs on a culture of commitment ... to our clients, to our proficiency, to exceptional delivery and to our colleagues inside and outside of our own firm. Learn more about the culture that differentiates Datavail.

Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.

Part II of our co-presentation with Black & Decker at KScope 2017. We discuss KPI, triggers, and health checks in Hyperion using Accelatis software, a company recently acquired by Datavail.

Show Transcript

Speaker 1: This chart shows some of the KPI features that we’re using. I won’t go through all of these, but it just shows things that we’re monitoring, or data that we’re capturing. And then our actions on the right show we can set triggers in Accelatis just so that we get notifications if we reach a certain threshold.

If you look at an example on the bottom for HFM, we’re tracking the task and data audit logs to make sure that those don’t get too big. This slide shows an example of those triggers or the emails that we get from Accelatis. My self and some of the other admins will get an email saying that the audit log reached a certain threshold, we need to go in and archive it. Then we run through our process that does that. It’s really nice that we get these during the close or whenever. It’s good and bad because you can get nervous when you start seeing them, but you can be proactive about doing what you need to do to minimize any impact on the users.

Speaker 2: There is an opportunity that we haven’t discussed, though, is that you can take that trigger and then tie it to an automation drop to actually do the archiving. So, it depends on your internal process. Some of the value is a trigger could kick off an automation job that could remediate the problem. And it just depends on what your internal processes are and whether you want to handle it annually or you want the system to do some of it for you. But a lot of these things can be connected pretty easily depending on and how far you want to go.

Speaker 1: This is one of our real life examples of how we use the health checks to troubleshoot an issue. We had several HFM users reporting slowness and poor response time. A lot of times you’ll get an email, “Hey, HFM is slow”. It’s like, okay, can you give me a little more detail, but when we start seeing multiple users saying that, okay we need to go check something out, we run right to Accelatis.

As an administrator, I try logging into HFM. I can get in, but I can’t navigate to system messages, so even I’m having issues. I have access to everything. So, we ran the health checks and the results of that are up here showing that the user simulation feature generated a failure and it also showed lengthy response times, not what we would normally see. The activity analysis feature showed that HFM was having issues with a specific sequel table related to HFM.

From there, we go to our DBA and the DBA found dead locks on the HFM data audit table. As an admin, when I couldn’t get into the system messages or the audit logs, that’s why there was a dead lock on the table. Then I wasn’t able to even get back into the application. Then we performed a restart. We stopped services, and rebooted, and everything came back okay. We logged in [inaudible 00:03:12] Oracle on the specifics of the dead lock on the table and We were able to provide them with all the logs and everything that they needed. It just shows how Accelatis helped us get right to the root of the area and how Oracle … we were able to quickly provide Oracle with what they needed so they could research it.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.