DBMSys Platform

The Microsoft MAP Toolkit is good for scanning systems and providing a snapshot of some system metrics. However, this toolkit doesn’t provide data over time to understand peak workload requirements and storage capacity needs.

DBMSys Platform turns monitoring on its head. DBMSys Platform not only helps with monitoring your environment for capacity needs. In addition, DBMSys Platform provides data over time, which is needed to make informed business choices on current and future plans for scalability, flexibility, and increased ROI.

You can use the DBMSys Platform for real-time database monitoring as well as database management services. This platform provides you with instant alerts on the dashboard and with convenient notifications. In addition, DBMSys Platform discovers the right path for database optimization and modernization for both on-premises and in the cloud.

Here are the top five reasons we urge our clients to consider using DBMSys Platform for their environment planning.

Capture Capacity

DBMSys Platform was designed to capture, process, report, and guide automation decisions based on metadata from multiple platform environments. DBMSys Platform uses an agentless central engine to collect varying kinds of data, both structured and unstructured, on nearly any infrastructure. The platforms and collection types covered by DBMSys Platform expand regularly.

Examples of what DBMSys Platform captures include:

• Operating System information
• Database-instance/Web Servers/Exchange/Active Directory level specific information
• Performance data
• Activity logs

Note: DBMSYS Platform does not access the content of any user table. All information collected by the application is available on the application’s database for review and auditing by the customer.

Running the Options

With the database server and hardware profile, operating system information, and metadata in hand, our solution architects can determine the risk to your business based on product supportability and new-feature adoption. Our first consideration is to look for databases and servers running on versions of the operating system or database server that are out of support or on extended support. These servers represent a business risk that you need to address. We also look for software running on aging servers.

Technology has advanced over the years with faster CPUs, greater memory capacity, and new storage technologies like flash-based solid-state drives. These servers are great candidates for consolidation and virtualization (Hyper-V and VMWare ESXi) on a modern host server or for moving to the cloud. The analysis also looks at database usage to determine if a server is a candidate for decommissioning or for scaling down in a consolidated platform due to its lack of use.

DBMSys Platform can also collect data from Oracle database servers to assess the possibility of migrating from Oracle to another database platform like SQL Server.

Database optimization for the cloud (Azure, AWS, GCP)

DMBSys Platform includes additional algorithms to compute the optimum configuration for moving the database applications to the cloud. You can choose either Microsoft Azure, Amazon Web Services (AWS), or Google Cloud Platform (GCP) environment.

By analyzing the workload usage data, DBMSys Platform can recommend specific Azure, AWS, or GCP VM sizes that match up with the usage data to determine if a database instance should be on a single VM or have multiple instances on a single VM. DBMSys Platform can also compute the estimated monthly costs using the latest billing information from Azure, AWS, or GCP.

Building the financial model

Building a financial model without current environmental metadata can be a daunting task. DBMSys Platform helps develop a model by showing a breakdown of the current state and by comparing the possible solutions that have been predetermined from the client’s guidance.

Some of the possible scenarios that can be compared include:

• Current state — do nothing
• Move existing servers to Azure, AWS, or GCP virtual machines with or without consolidation
• Perform Consolidation among existing on-premises servers
• Virtualize existing on-premises servers to Hyper-V/VMware

We seek to empower our customers with their data to help make the best business decisions possible regarding their future state architecture. Our customers must have a full understanding of the overall cost model with input from DBMSys Platform and our engineers.

Many of our customers consider Azure Database Managed Instances as the target destination for their database upgrade or migration. DBMSys Platform supports Azure DBMI and provides a comprehensive financial estimate of this type of database modernization.

With our exclusive Data Management Optimization offer, you can take full advantage of your new database environment within a short time. And with the DB Best Migration Platform you can be sure that your migration stays in line with a proven and successful path.

Health monitoring and keeping systems running, patched, and updated

With DBMSys Platform, we can provide database health monitoring, upgrading, and patching all through one platform. DBMSys Platform can also be used for many other reporting and environmental tasks that require a real-time monitoring system to help guide the decision-making process.

We deploy DBMSys Platform for long-term engagements to assist with database monitoring and database optimization. In addition, DBMSys Platform provides us with system status and other business-rule requirements. DBMSys Platform displays metadata on a single health dashboard.

Also, DBMSys Platform takes real-time alerts, events, and metadata and uses predefined business rules to create targeted alerts and actions. This gives your infrastructure and database teams greater control over the environment.

DBMSys Platform also allows for automating event monitoring. Particularly, we created an extensive list of events based on our expert’s knowledge and industry best practices. DBMSys Platform checks on the pre-defined schedule and sends out notifications in case of an alert. Also, DBMSys Platform can send reminders if the alert was not properly addressed.

Currently, we use the DBMSys Platform for database monitoring in various projects with our customers. As the developers of this platform, we can easily customize it to meet the customer’s needs.