The average DBA manages 200 databases and it’s impossible to monitor them all closely. Famteck’s flagship software, Instance Resolve (IR) leverages new technology and mobility to provide a next generation application—complete with dashboard—that provides real-time Oracle and SQL Server monitoring to enable capacity planning and trending analytics. By merging features from custom scripts, Enterprise Manager, TOAD, Fog Light and other tools into one consolidated view, DBAs receive real time and predictive data that can identify potential challenges to the system before they can occur resulting in faster decisions and resolution of issues. IR finds relationships in data—perhaps not be readily apparent with descriptive analysis—and translates those findings into actionable data and analytics. This allows the database team to be more productive and proactive, doing more with less resources, and still achieve optimal performance.
Our key mission is to make the DBA’s job easier which will result in increasing revenue for the organization
IR can also provide tracking and trending of the database and storage over many years. With the consistent triple digit growth rates of databases, developing an archive or purging strategy while increasing optimal application and database performance is a best practice of database management and reduces the need to purchase additional database storage. Through the trending data, an IT team can see exactly how the database is growing, which tables are growing and why. “More hardware is not always the best solution,” says Meertins. Famteck’s software provides its customers details and insights into what is consuming space, including storage charge-back information. In addition, all SQL statements are analyzed and the worst performing SQL code is identified to the team with detailed information and a Database Health Check, identifying potential sources of slow application performance.
Famteck’s roadmap includes an annual investment of 20 percent in R&D which continuously evaluates new solutions that may align with customers’ requests and solutions that can easily be implemented within their suite of products. Team members are sent to various training events and collaboration with Famteck’s partners, vendors and solutions providers is required to stay abreast of potential options for customers. Per Meertins, “Our key mission is to make the DBA’s job easier which will result in increasing revenue for the organization.”