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.

Links

Joe on SQLblogs

Joe on SQL-Server-Performance

Solid Quality Journal

Joe at SQL Rally Nordic, Copenhagen, 2 or 3 Oct 2012

Presented at SQL Saturday Riyadh May 2013

Storage 2013

SQL Performance 2013 (Special Topics)

Presented at SQL Rally Copenhagen Oct 2012

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 Presentations

Performance for Small/Medium Business

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 ?

 

Work in progress: my article on Relativity e-discovery and SQL Server.