How can I check the Long Running Query by using Stats..

Question

How can I check the Long Running Query by using Stats..

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

doug.brown SSCertifiable Points: 5608 More actions · Answer 1

Query tuning is a complex art, but Grant Fritchey's book on execution plans is a good resource to start with. It's available as a free pdf here:

http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2

Jack Corbett SSC Guru Points: 184395 More actions · Answer 2

You can do this to get the plan:

SELECT

DEQP.query_plan

FROM

sys.dm_exec_query_stats AS DEQS

CROSS APPLY sys.dm_exec_query_plan(DEQS.plan_handle) AS DEQP

WHERE

[some criteria to determine what is long running]

Then you can examine the execution plan to determine where/what to start stuning.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Chowdary's SSCrazy Points: 2978 More actions · Answer 3

Thank u All.....

is there any Video Links for that Query Tuning...

Regards
Chowdary...

free_mascot One Orange Chip Points: 27164 More actions · Answer 4

You can find lots on google. Select as per your need.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

doug.brown SSCertifiable Points: 5608 More actions · Answer 5

I got some good tuning tips from this Brent Ozar video:

http://www.brentozar.com/archive/2014/01/watch-brent-tune-queries/