Query Hash Statistics, a query cost analysis tool, now available for download

Some time ago I described the query fingerprint and query plan fingerprint (a.k.a. query hash / query plan hash) features that were added in SQL Server 2008.  A fingerprint identifies all queries or all plans that have the same “shape”.  With query fingerprints you can get the cumulative cost of all executions of a query…

1

SQL Server Sizing Resources

Recently, I was asked whether Microsoft had any SQL Server hardware sizing tools.  The asker referred me to http://www.sizinglounge.com as an example of what he was looking for.  (Sizing Lounge apparently allows you to select an app like SAP or Exchange, answer a couple of questions about things like concurrent user counts and desired CPU utilization…

1