Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talking about regularly executed queries. Design time decisions that were made with the given the statistics at the start of the project may not make sense with the new data and query patterns. So, this means that the Amazon Redshift cluster requires some optimization. See how these Amazon Redshift performance tuning tips can improve query execution […]
Learn more about
Improving the performance
Talks on Managing Data and Applications Anywhere
One of our customers needed to migrate their Ingres Database system to Microsoft SQL Server wanting to improve the performance of their system. We came up with a migration solution and updated the business logic module of their application. As a result, the customer achieved a sufficient performance increase, improved the database system security, and got an optimized business logic architecture. The video below depicts the migration process in details:
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.
Join Robert L Davis, Principal Database Architect at DB Best Technologies, for a free webcast through MSSQLTips.com on Thursday, August 13, 2015. Robert will be presenting SQL Server Performance Tuning: Controlling Parallelism. Webcast description: Parallelism seems like it should be one of those things that the query engine takes care of for us, but it does require some care and tending from time to time. The default server configurations are no longer adequate for controlling parallelism, and DBAs need to […]