QDPMA Joe Chang SQL Server Consultant

SQL Saturday and Other

Presenting at SQL Saturday Riyadh, Saudi Arabia, Thurs 23 May 2013. Was not simple, but visa just came through.

Articles

In previous articles, I have discussed processor and system architecture, server systems, and performance benchmarks, often mixing more than one topic. Going forward, I will consolidate each topic into separate collections:

Query Optimizer and Performance formerly "The SQL Server Cost-Based Optimizer"
Feature: Path to In-Memory Databases - Hekaton

Server Systems Updated 2012-10

Storage Updated 2013-03
New Storage Performance 2013

System Architecture

Processor Architectures
Feature: Hyper-Threading performance on TPC-H queries.

Performance Benchmarks

TPC-H Studies
SQL Server scaling and other characteristics are investigated using the TPC-H data generator and test queries. The test conditions are not identical with publication requirements.

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

Standalone Articles

About 64-bit

Gigabit Ethernet

SIMD Extensions for the Database Storage Engine

SQL Performance Tools

SQLExecStats documentation, in the process of being updated, ~~ok, the documentation is seriously out of date~~.

Some time soon, I will move SQL ExecStats from .NET Framework 2.0 to 3.5. For people who are SQL Server 2005, this just means it will be necessary to install .NET 3.5. I am certain that in .NET 2.0/SQL Server 2005, the SMO libraries were 32-bit only. Now there are 64-bit versions as well. Some I will try allow reading execution plans from SQL Trace files as well.

Downloads

SQL Exec Stats, .NET Framework 3.5 or 4.0?
Exec Stats has now been combined with SQL System,
I expect there to be some bugs, so please report and I will work it out.

This link should redirect to the latest version (1.50), which is really work-in-progress: Exec Stats (Requires .NET Framework 3.5, Build 2010-12-05 and later will require SQL Server 2008 Feature Pack - Management Objects) The more stable 1.3 version (2011-06-15) is still available below.

  Build 2013-05-02f corrections for SQL Server 2005
  Build 2013-04-27 revisit XML plan to tree
  Build 2013-03-10 new - needs testing
  Build 2013-02-06 data reader error handling

I am contemplating implementing a very basic graphical plan. I would rather not do this as SQL Sentry has a well reviewed Plan Explorer, but it would be useful.

Older versions have been removed. Send me an email if older versions are desired for some reason.

SQL System

SQL System has now been rolled into Exec Stats

Trace Analysis
Trace Analysis Build 2012-10-26
Trace Analysis Build 2009-01-11

SQL Clone
Build 2010-03-04
This is an interim update for scripting Roles. A more thorough update is due, when I get a chance.

Build 2009-01-18

SQL Scripts

Trace is my standard Profiler script. Be careful in collecting execution plan information, as this could have high overhead.

Old version Table Spaceused Summary reports size, indexes, and other info.
I am working on a new version for lumping internal tables together, New Table Spaceused Summary

Index Summary with key and include columns, size, and dmv index usage stats.