SQL Server licensing
Server consolidation and virtualization for optimizing SQL Server licensing expenses
28 Nov 2018

One of the leading US agricultural suppliers wanted to upgrade their SQL Server system in order to reduce their overall SQL Server licensing expenses. We performed a thorough financial and technical analysis of their existing OLTP and BI/OLAP database system, and provided a number of optimization suggestions. In addition, we delivered a modernization roadmap to give the customer an idea of potential future plans. Discover how we approached this project from the following video. Complex customer’s system Before our customer […]

Performing a comprehensive SQL Server Database Health Check
Getting the most out of a comprehensive database health check for SQL Server
22 Aug 2017

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 cloud. We helped them by using our DBMSys service to perform the overall database health check. As part of the database health check, we found several high priority issues which required immediate actions. In addition, we provided the customer with detailed information on their existing database system, […]

Enhancing SQL Server database performance by 3x acceleration of queries execution
Enhancing SQL Server database performance by 3x acceleration of queries execution
06 Jul 2017

A leading provider of business management solutions currently hosts many of their workloads using SQL Server databases on Azure. They faced a number of SQL Server database performance issues and needed an efficient solution to resolve them. We analyzed the customer’s system and delivered instructions with detailed descriptions. They covered all discovered issues and described the possible approaches to fix them. With our instructions, our customer achieved more than three times better overall query performance. 

Building detailed modernization roadmap for outdated databases using DBMSys
How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%
22 Jun 2017

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 built cost-effective and highly optimized modernization roadmap using our DBMSys platform. Using our detailed instructions they can substantially cut the upgrade expenses and take advantage of their workloads migration to Azure along with benefits from virtualization and consolidation options.

Upgrading unsupported databases using DB Best novel tools
Automated sniffing technology of upgrading the unsupported SQL Server versions
16 May 2017

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 system. Moreover, Microsoft upgrade tools can’t handle such outdated database versions as SQL Server 2000. With our innovative database discovery and monitoring tools, we were able to perform an inventory of their system. We developed an upgrade factory to get them back within Microsoft compliance. Now our customer has deep insight into […]

5 essentials to learn about your data platform with DBMSys
28 Sep 2016

DBMSys is a lightweight tool designed by DB Best specifically around collecting data from multiple environments to help develop a business case for a modernization to upgrade path. The Microsoft MAP Toolkit is good for scanning systems and providing a snapshot of some system metrics, but doesn’t provide data over time to understand peak workload requirements and storage capacity needs. DBMSys turns monitoring on its head. Not only does DBMSys help with monitoring your environment for capacity needs, it provides […]