Calculate the effort of a query | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Calculate the effort of a query

Hi there! I need to calculate the effort of a query before actually sending it to the SQL Server. Is there a way to do it? Cheers,
Ingmar
I suggest you can find in Query Analyzer "Performance tool" available, there you will find Query Estimation… which gives actual statistic’s.
Hi Girishmk! Thanks for your reply. What I need though is something that’s available in a programmatic way, meaning: The customer operates a web interface that allows him to assemble a search based on multiple criteria. The tool has to calculate the query’s effort before actually executing it. If the effort turns out to be too high, it mustn’t be executed in order to prevent SQL Server lockdown. Cheers,
Ingmar
]]>