Data Warehouse, Clustered Columnstore Indexes and SAS

Clustered Columnstore Indexes (CCI) is a game changer for data warehouse workload, which is available from SQL Server 2014 Enterprise Edition. I worked for a PoC project last year to adopt Clustered Columnstore Indexes for data warehouse. The PoC method is simple but the improvement is very significant. Below is some detailed. The Pain and…

0

SQL Performance Tuning – 3 Using MDW to T-shoot Performance Degradation

Management Data Warehouse is a great tool to create SQL Server performance baseline. Below are the steps I recommend my customer to use Management Data Warehouse to find out possible root causes for performance degradation scenario, which means the application response time was in acceptable level previously but now end users are complaining it’s slower…

0

SQL Performance Tuning – 2 Accessing Data

One approach to speed up application response time is to take advantage of cache. Cache in computing means a hardware/software component that stores data for future quickly use. Why we don’t use a faster component for as permanent storage but a temporary storage? Sometimes it’s because the cost difference, and sometimes it’s because technology is…

0

SQL Performance Tuning – 1 Overview

SQL performance tuning is a huge topic, and you need to know many detailed info of behavior with different version of OS and SQL. I will share my general approach of such work in 4 – 5 posts. Before Tuning The first thing you should keep in mind is end users don’t care SQL, they…

2