Consideration of Hardware Resource Sharing

After the change of SQL Server license scheme, many of my customers are asking help to consolidate their SQL to maximize the investment of hardware/software. There are 3 methods to share the hardware resource: Method 1: One SQL Server instance shared by multiple databases Method 2: One Windows/Cluster shared by multiple SQL Server instances Method…

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

Ask Me Question

I’m Shiyang Qiu, technical lead for SAP on Azure in Greater China, Microsoft Global Black Belt team. I’m one of the Microsoft Certified Solutions Master – Data Platform in Asia. In the past decade I support Microsoft customer to adopt new features, design data tier of the high data volume high performance applications and BI projects, and dedicate to move mission…

0