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 not only helps with monitoring your environment for capacity needs. In addition, DBMSys 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 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 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 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 expand regularly.

Examples of what DBMSys captures include:

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

Note: DBMSYS 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 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 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 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 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 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 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.

Health monitoring and keeping systems running, patched, and updated

With DBMSys, we can provide database health monitoring, upgrading, and patching all through one platform. DBMSys 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 for long-term engagements to assist with database monitoring and database optimization. In addition, DBMSys provides us with system status and other business-rule requirements. DBMSys displays metadata on a single health dashboard.

Also, DBMSys 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 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 checks on the pre-defined schedule and sends out notifications in case of an alert. Also, DBMSys 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.