Sql server 2008 provides powerful feature to capture expensive queries using query identifier also called as query finger print.

Whenever sql server executes any query, it will generate unique query_hash which will be used to troubleshoot expensive queries.

All Compiled plans can be retrieved from plan_handle and sql_text can be retrived from sql_handle.

In order to demo […]