QDPMA

QDPMA.com - SQL Server Consultant - Joe Chang

About Joe, Contact: jchang6 at yahoo.com or jchang61 at outlook.com

Joe's travel plans 2018

Committed: Nov 6-9, PASS Summit 2018, Seattle
PASS Rethink Server Sizing

Pending:

Categories and Feature Articles

Query Optimizer and Performance  formerly "The SQL Server Cost-Based Optimizer"
  Mysterious Performance Symptoms in SQL Server 2018-07
  kCura Relativity 2013-04, updated 2013-09
  Path to In-Memory Databases - Hekaton

Server Systems and Architecture  2018-Aug
   Multi-Processors Must Die (2018-08)
   Intel 10nm Delay Assessment (2018-08)
   Memory Latency (2018-04)    TPC-E Benchmarks (2018-04)
   DRAM (2018-03)    SRAM as Main Memory (2018-03)

Storage  
  Transaction IO Performance on Violin (2015-02),
  SAN IO Performance Problems (2015-02),

System Architecture   (being merged into Server Systems and Architecture)

Processor Architectures   Updated 2016-12 new die images scaled
    Intel processor die images (mainline desktop)

Performance Benchmarks  
    Parallel Execution in SQL Server 2016 (2017-01).
    Hyper-Threading performance on TPC-H queries (2013-03).

Performance Tools

ExecStats is my own SQL Server performance analysis and data collection tool. Please try it out and send feedback. SQL Exec Stats has been combined with SQL System as of 2012 Q4,

Download       Exec Stats (latest, .NET 4.61, 2018-06-23)

  Exec Stats 2018-07-23 incorporates 7zr.exe, auto-compresses to 7z

  Exec Stats 2018-07-19 test version, console mode -c

  Exec Stats 2018-06-23 now tracking open xml handles and cursors.
Also getting procedure, function (2016) and trigger exec stats,
tbd: get trigger plans?

SQL Scripts

  spaceused with table level details (2018-02)

  sp_helpindex2

  sp_partitions (2018-02-23)

  sp_updatestats2 system procedure identifies such indexes and applies a full scan update.

  sp_vas (2018-07) for tracking virtual_address_space_reserved.

Standalone Articles

Also on Linkedin articles (these are older versions of the two above articles):
  Multi-Processors Must Die   Intel 10nm Delay Assessment
  Mysterious Performance Symptoms in SQL Server  
  SRAM as Main Memory Cost Benefit   Rethink Server Sizing 2017  

 Climate, not my field, but I had to look into it.

 About 64-bit

 Gigabit Ethernet

 SIMD Extensions for the Database Storage Engine

How to approach SQL Server performance

I made this for a talk a few years ago. I liked it so much that it is now in all my slides.

Natural

Of course, that does not mean it is complete, so please send feedback via Joe on SQLblogs
SQL Blog unfortunately seems to be dying, please send comment to emails at top.

Events and Presentations

2018

Feb 10, SQL Saturday 696 Redmond, Rethink Server Sizing,   (pdf)

2017

Data Architecture Summit   Is Performance Still Important   slidedeck

2015

2015 Jun 20 SQL Saturday Bratislava Comprehensive Indexing 2015
2015 May 30 SQL Saturday New York Comprehensive Indexing 2015   OK, same slidedeck for both.

2015 Mar 04 Copenhagen, SQL Rally Nordic, Automating Execution Plan Analysis 2015 (Updated)

2015 Jan 22, Oslo SQL Server User Group Norway at Teknologihuset
Statistics That Need Special Attention

2014

Joe presented at SQL Saturday Oslo, 30 Aug 2014
Modern Performance 2014 Oslo

Redmond, 31 May 2014   Automating Execution Plan Analysis for Comprehensive (Whole DB?) Performance.

NOVA, 19 May 2014 Modern Performance 2014

SQL Saturday Atlanta, 3 May 2014

SQL Saturday Budapest, 1 Mar 2014
I was at SQL Saturday Boston on 29 Mar, but not presenting.

2013

2013 Oct 6 at Silicon Valley Code Camp

Modern Performance 2013 (updated 2013-10-06, original 10-03)
Note: Modern Performance-SVCC, the SQL Performance 2013-Riyadh and the 2012 Automating Performance-Copenhagen slidedecks are all on the same topic.

2013 May at SQL Saturday Riyadh, Saudi Arabia

Storage 2013

SQL Performance 2013 (Special Topics)

2012 Oct 2 & 3 at SQL Rally Nordic, Copenhagen

Automating Performance Data Collection, Analysis etc.

Presented at SQL PASS Deutschland

I presented at Munich on 10 Jan 2013. Will put up slides soon?

SQL PASS Deutschland

SQL Server Query Optimizer Cost Formulas 2010-Dec?

2011 SQL Saturday Trinidad Presentations

Performance for Small/Medium Business

SQLBits 2010

I presented a session at SQLBits on 1 Oct 2010 in York, England. (if this where New York was named after?) Anyways, I tried to squeeze 4-5 hours of material into 1 hour. So I will try to write up everything and collect it here.

  1) NUMA System Architecture
  2) Storage Performance for Data Warehouse
  3) Parallel Execution Plans Part I, Part II, Part III
  4) TPC-H Benchmarks, SF100, SF300, SF1000, SF3000
  5) TPC-H Studies at SF10

Slidedecks: SQLBits Presentations

SQL Server 2008 Presentations

SQL Server Query Optimizer Cost Formulas

Storage Configuration, NOVA 2009

SQL Server 2005 Presentations

SQL Server 2005 Performance Enhancements for Large Queries

SQL Server 2000 Presentations from past conferences

Execution Plan Cost Formulas

Quantitative Performance Analysis, CMG2004

Loop Merge and Hash Joins

Insert Update Delete

Large Data Operations

Parallel Execution Plans

Storage Performance, Connections Spring 2005 ?

 

Joe on SQLblogs

Joe on SQL-Server-Performance

Solid Quality Journal

 

Citations

Efficiently Clone Databases by Kevin Kline

Optimizing Power for SQL Server ... by Jimmy May

Logical I/Os – Not a useful performance metric? by Joe Sack

An Introduction to Cost Estimation Benjamin Nevarez

I posted this HealthCare.Gov Fiasco back in 2013.

I noticed this link at GSU HealthCare.Gov Fiasco for PMBA 8125 course, 2014, taught by Duane Truex?.

 

 

In case anyone is interested, the old frameset page is here wframeset.html. I never figured out how to code it.