Microsoft SQL Server Performance Tuning

There are thousands of companies using Microsoft SQL Server database for their OLTP and OLAP operations.  In recent years, many of them are facing serious performance issue with the rapid growth of data volume.  If your database is more than 6TB in size or 1 table with more than 300GB, you are likely listening to complaints by users every day. 

With our expertise in handling data for years, we are helping clients to improve their database performance.  To take an example in a fortune 500 corporation, we have a client with a SQL database more than 10TB in size.  Some of their SQL queries and stored procedures were running for more than 60 minutes. 

To improve the performance, we have carried a number of tasks:

1. recommend the changes of storage arrangement.
2. Rewrite some SQL queries and sub-queries
3. Apply partition tables for those needed
4. Apply compression on tables necessary

There are 2 examples below to compare the performance before and after our tuning tasks.

For the tuning above, there is no additional investment in hardware like buying more rams and CPUs.

If you are facing such a problem, talk to us.  Our consultants are focused on data management and data science for years and provide different data and analytics solutions.