Presenting at SQL Saturday Riyadh, Saudi Arabia, Thurs 23 May 2013. Was not simple, but visa just came through.
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 2012-10
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.
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
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.
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.
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 has now been rolled into Exec Stats
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.
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.
SQL Performance 2013 (Special Topics)
I presented at Munich on 10 Jan 2013. Will put up slides soon?
SQL Server Query Optimizer Cost Formulas 2010-Dec?
Work in progress: my article on Relativity e-discovery and SQL Server.