QDPMA - SQL Server Performance Consultant - Joe Chang
About Joe, Contact: jchang6 @ yahoo.com
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:
Server Systems Updated 2014-02
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.
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,
I am abandoning the specific build links with a generic that should point to the latest. Current build date is 2013-10-06 per date in the file name, and not necessarily the timestamp, which can vary by time zone.
The general link is normally for the latest build, but it will remain on the last .NET 3.5 for a while.
Download Exec Stats (latest, .NET 3.5, 2013-11-05)
Exec Stats 2014-03-08 error handling for missing perf counter
Exec Stats 2014-02-24 minor
Exec Stats 2013-12-13 interim build intended for Windows Server 2008 R2 using the new Processor Information object instead of Processor. Has not been tested on W2K8 original yet. Later builds will report the processor frequency once issues are worked out.
Exec Stats 2013-11-05 last stable?
Exec Stats 2013-10-11 (.NET Framework 4.0) might work with Azure?
Exec Stats 2013-10-06 (.NET Framework 3.5)
SQLExecStats documentation, in the process of being updated,
ok, the documentation is seriously out of date.
Every time I update the documentation, I make further changes to ExecStats,
obsoleting the documentation changes just made - oh well.
Sometime I will try allow reading execution plans from SQL Trace files as well. 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.
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
Climate, not my field, but I had to look into it.
SQL Performance Tools (Obsolete)
Older versions have been removed. Send me an email if older versions are desired for some reason.
This is an interim update for scripting Roles. A more thorough update is due, when I get a chance.
Trace is my standard Profiler script. Be careful in collecting execution plan information, as this could have high overhead.
The New Table Spaceused Summary (2013-09)
Old version Table Spaceused Summary (2008?) reports size, indexes, and other info.
Spaceused Summary (2012-04)
Index Summary with key and include columns, size, and dmv index usage stats.
Events and Presentations
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
SQL Performance 2013 (Special Topics)
2012 Oct 2 & 3 at SQL Rally Nordic, Copenhagen
Presented at SQL PASS Deutschland
I presented at Munich on 10 Jan 2013. Will put up slides soon?
SQL Server Query Optimizer Cost Formulas 2010-Dec?
2011 SQL Saturday Trinidad Presentations
SQL Server 2008 Presentations
SQL Server 2005 Presentations
SQL Server 2000 Presentations from past conferences
In case anyone is interested, the old frameset page is here wframeset.html. I never figured out how to code it.