Software development, .Net, SQL Server, TDD, Agile, Community and other Odds and Sods
Thursday, May 12, 2011
SQL Server 2008: Query Hash Statistics
Bart Duncan has released a very useful addition to the DataCollector capture/reporting abilities of SQL Server 2008. Query Hash Statistics can do low-overhead query cost monitoring, utilising the query fingerprint and query plan fingerprint (aka query hash/query plan hash) features that were added in SQL Server 2008. Query fingerprints enable you to get the cumulative cost of all executions of a query even if the query is non-parameterized and has different inline literal values for each execution. Previously, the only way to get this type of query performance data was to capture a Profiler trace and run the trace through a post-processing tool.
Once installed, and sufficient data has been collected, you can access the collected information via 2 custom reports.
MSN, Email: mitch døt wheat at gmail.com