SQL Server 2017 AWS EC2
Are you getting the best value out of AWS EC2 running with SQL Server 2017?
25 Oct 2019

Last year, we published the blog post on Validating AWS EC2 SQL Server Deployments Using Benchmark Tools. Since then, AWS released enhancements like Optimizing CPU Option that allow you to choose a larger EC2 instance for your SQL Server 2017 instances for greater Memory and IOPS / vCPU to keep your licensed vCPU count down.
Read this bog post to discover how benchmarking your SQL Server workloads on AWS in a pre-production environment can help you pick the best candidate EC2 instance with an optimized storage configuration based on real data.

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 […]

Validating AWS EC2 SQL Server deployments using benchmark tools
16 Nov 2018

As cloud computing becomes more and more popular and demanded among our customers, quite often we at DB Best need to answer the simple question: “How can I get the best value for running my SQL Server workloads on AWS EC2 instances?”. Issues like mistakenly using older generation EC2 instances or not optimizing your EBS volumes can prove to be costly. Likewise, not all hardware supporting the AWS infrastructure is created equal, despite the fact that they try to keep […]

Validating Azure SQL Server Deployments
Validating Azure SQL Server Deployments Using Benchmark Tools
08 Nov 2018

If you have been deploying SQL Server workloads to the Microsoft Azure platform using virtual machines, you may have noticed that not all virtual machines, solid-state drives, and network components are created equal. There might be issues in your deployment templates that could result in SQL Server not performing as well as expected. For example, in a presentation given by André Arko at StrangeLoop 2016, André claims that Netflix benchmarks AWS EC2 instances that they use for production and if […]

Azure SQL Database Hyperscale
Top 3 Azure SQL Database Hyperscale Benefits
08 Nov 2018

When customers feel the need for speed and size, Microsoft announced at Ignite a new service called Azure SQL Database Hyperscale. This service offering is now available public preview as of October 1, 2018. Think of this as cloud-based Oracle RAC for SQL Server or Amazon Aurora for SQL Server in terms of the ability to scale SQL Server up to 100 TB! Like Azure Synapse Analytics, Microsoft separated the Compute processing from the Storage so that you can dial […]

Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
25 Jan 2018

One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormously huge database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. DB Best provided the customer with the day-to-day operational data management services both on-premises and in the cloud, as well as configured the new architecture for their cloud-based system. Discover the benefits […]

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, […]

Virtualization and consolidation of SQL Servers during a complex database system upgrade
31 Jul 2017

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 virtualized system. In addition, we found some server consolidation opportunities which would improve the overall system’s performance. As a result, we helped our customers deploy the newly created system in production. Moreover, we delivered a comprehensive list of best practices for evident and accessible management of their environment. Learn more […]

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 […]