DBMsys Platform Essentials

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 the monitoring on its head. Not only does DBMSys help with monitoring your environment for capacity needs. In addition to that, 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 DBMSys platform for real-time database monitoring as well as database management services. This platform provides you with instant alerts both on the dashboard and convenient notifications. In addition to that, DBMSys discovers the right path for database optimization and modernization 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 going to be 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 the 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; 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 what the current state is and 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/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 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.

DBMSys Data Management Optimization

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 to that, 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.

In addition to that, DBMSys 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.

DBMSys automated database events monitoring

Currently, we use 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.

Learn more about DBMSys Platform
Contact us

How DB Best can help you with DBMSys

DBMSys leverages your environmental data to allow for informed business rules as well as data-guided estimates and upgrade or migration paths. In order to get the best value from DBMSys, we like to have our engineers leverage it as part of our existing services and solutions.

DBMSys provides all of the metadata, but we also add our own “Special Sauce:” The vast experience of our architects are consultants.

If you would like to know more about DBMSys and how DB Best can better leverage your own environments metadata to help better inform your decision makers, contact us. No company is too small or too large for what DB Best can offer with DBMSys and our experienced team of subject matter experts (SMEs).

Check out our getting started offers that feature the use of DBMSys.

Introducing DBMSys

Watch how the DB Best in-house database management software, DBMSys, can get your database systems healthy over time both on-premises and on the cloud.

Let's get together to talk about DBMSys Platform
Contact us today
Contact us today to get started with DBMSys Platform
Contact us

Learn more

Blog posts

To see how we’ve applied DBMSys as part of our practice and how customers have benefitted from our DB Best DBMSys platform, check out the following blog posts.

12 sure steps to SQL Server upgrade success
2 August 2016 admin

Upgrade and modernization projects for SQL Server should not be taken lightly. You might want to take advantage of the latest versions of SQL Server 2016. You might need to take your a...

Automated sniffing technology of upgrading the unsupported SQL Server versions
16 May 2017 Stanislav Andrenko

Our customer needed a way to upgrade their unsupported SQL Server databases to newer versions of SQL Server. The major challenge was that they didn’t have visibility into their syste...

How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%
22 June 2017 Stanislav Andrenko

A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and ...

Developing Access modernization roadmap for highly outdated environment
5 October 2017 Stanislav Andrenko

A major Health Department was running a data system that has been expanding over the years. Eventually, they ended up with a highly outdated and inefficient environment with thousands ...

Getting the most out of a comprehensive database health check for SQL Server
22 August 2017 Andrei Ivanov

One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the...

Virtualization and consolidation of SQL Servers during a complex database system upgrade
31 July 2017 Andrei Ivanov

One of the largest US national energy suppliers wanted to upgrade their SQL Server system and deploy it on VMware. As a consulting partner, we offered a new architecture for their vir...

Reference data sheet

Check out our data sheets on how DBMSys can work for you to get the most value from your SQL Server deployments and keep them running within your service level agreements and policies.

 

Data Management Optimization
22 August 2016 Bill Ramos

DB Best has  five key areas we focus on when proposing our customized modernization map. Our data-centric approach involves an in-depth look at your organization's data platform so w...

Data Management Services
18 August 2016 Bill Ramos

Mission-critical systems drive your business, yet most organizations lack the IT expertise or resources to maximize system performance and achieve greater service availability, complia...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote