SQL Server - how to findout big queries consume in sql server 2008

hi,

how to find out big consuming queries on databases in sql server 2008.........and how to find out the optimizing query

Please anyone help me.......related answers.......

You need to analysed execution plan to see consume time on each and every step means time for filter , searching fetching etc step by step.
See this article to details about exectuion plan
http://blog.sqlauthority.com/2007/08/28/sql-server-actual-execution-plan-vs-estimated-execution-plan/ 
http://sqlserverpedia.com/wiki/Examining_Query_Execution_Plans 

Hello Friend,

this http://www.mssqltips.com/sqlservertip/1776/automate-performance-monitor-statistics-collection-for-sql-server-and-windows/tell complete performance tuning and monitoring. and also contains detail about  various tools used in performance check



Hope this helps

Regards
D

You can runt the Trace to find out what queries are consuming the most.